Dynamic query and record source in a Form

dudezzz

Registered User.
Local time
Today, 01:28
Joined
Feb 17, 2005
Messages
66
I have Form A that has a combo box and a "Submit" button. When the user clicks on the Submit button it needs to open Form B. Recordsource of this Form B is "Query B"

Item selected on the combo box becomes the criteria for "Query B and Form B needs to be opened based on that criteria.

What is the easiest and fastest way (no dlookups please!) to do this?

If an illustration is possible through an example that will be wonderful.

Thanks in Advance.
 

Users who are viewing this thread

Back
Top Bottom