data populating from drop down menu

[mdhr]

Hi,

I am trying to make a drop down menu and populate the data of the selected object.

when selecting a city from the drop down menu, the resulting table or query should display all the details of the selected city.

I hope to find some solution here.

Thank you.

 

[Ranman256]

The query for the combo box that holds the details, should use cboCity in its criteria....
Select detail from table where city = forms!myForm!cboCity

But you must put a requery in the AFTERUPDATE event so the cbo box it can see the new pick...

Sub cboCity_afterupdate()
CboDetail.requery
End sub

 

[mdhr]

Thanks Ranman!!

I am new to Access so i couldnot catch up with your explanation. Could you explain more in detail? where shall i write the code
and the cboCity?

 

[Ranman256]

Yes, in cboCity...
Select cboCity, properties, events tab, AFTERUPDATE event box,
Click the ellipsis button in the box,
Click CODE,
Put the code here.

 

[mdhr]

Cannot I write formula in the query, to give the detail of the selected object?

In the query, populate the data of the city Hamburg only, if Hamburg is selected in the drop down menu in the table.

Is there some way to achieve this?

I am trying to do it with the lookup table.