Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing an argument from Form to OpenForm

Status
Not open for further replies.

axilla2

IS-IT--Management
Jan 24, 2003
11
GB
I have a form with a drop down that lists a few choices for my user. I want to pass the user's selection from that combo box to DoCmd.OpenForm (in acFormDS).
In other words, open a form in Datasheet view and filter it based on the criteria the user picked in the drop down menu.

I'm totally stuck, very much a beginner in VB, I cant figure out how to pass the args or refer to the drop down box for that matter.

please help with your advice,
many thanks-
 
Here is something very similar to what you are asking. Check out the thread below.

thread181-456002

If you have any questions about it, let me know.

Hope this helps you.

Jon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top