Site to find how to filter a drop down list?

[Bob]

I am trying to find out how to select a record in another form with a drop
down list. I have the Query, the dropdown list , just need to find out what
I have to do so when I select a row it will produce the Form/Record
thanks For your help...Bob







..........Jenny Vance

 

[Arvin Meyer [MVP]]

I am trying to find out how to select a record in another form with a drop
down list. I have the Query, the dropdown list , just need to find out
what I have to do so when I select a row it will produce the Form/Record
thanks For your help...Bob







.........Jenny Vance

 

[Arvin Meyer [MVP]]

Sorry, pushed the send button way too soon.

Use the following code in the after update event of your dropdown list:

DoCmd.OpenForm "YourFormName",,,"IDField =" & Me.NameOfDropDownList

--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Bob]

Brilliant Arvin I've been trying for 2 weeks to do that....Much
appreciated..Bob