please help on how to use automate on ms access?

Question

like if i choose a certain province on my list automatically all the municipality will appear on my next list to choose

Answer 1

Lets say the province list is named [List1] on form [Form1]. The municipality list is [List2] on same [Form1]. You have a table named "Municipalities" with columns "City" and "Municipality" (in that order).

Set data source of [List2] to
"Select * From Municipalities Where Municipality = " & [Form1]![List1]
Format [List2] to show 1 column.