Can i make a user choose a certain

[Oblivion_Creed]

I want to make a user fill the city where he lives and the street in the city where he lives.



now i have 2 tables:

city
street

in street i can create a street after choosing the city in which the street is.
How can i make the user choose only streets from the city he filled

[CJ_London]

you need to make your street control a combobox and have its rowsource with a criteria to select your streets based on the city entered. e.g.

On a form you have a textbox - txtCity

and your combo (cboStreet) would have a rowsource of "SELECT Street FROM tblStreets WHERE City = '" & [txtCity] & "'"

and finally a bit of code in your cboStreet on enter event

me.cboStreet.requery

[Oblivion_Creed]

you need to make your street control a combobox and have its rowsource with a criteria to select your streets based on the city entered. e.g.

On a form you have a textbox - txtCity

and your combo (cboStreet) would have a rowsource of "SELECT Street FROM tblStreets WHERE City = '" & [txtCity] & "'"

and finally a bit of code in your cboStreet on enter event

me.cboStreet.requery

Im really new to Access and i have no idia what "combobox" is and what text do i have on a textbox....

could you please make a more detailed guide for that?

[CJ_London]

Appreciate you have to start somewhere, but only if you provide more detail about your tables and the reason for the database, how you want it to work etc., otherwise it is pure conjecture

Before doing so, you might want to make use of google/bing to find out a bit more - google 'access textbox' and 'access combobox' for example and take a look at the template databases provided with access to gain a better understanding. You will also find plenty of training videos and examples online