Form Selecting Record! Help

[Jchristensen]

I have a couple querys that rely on this statement:

Like "*" & [ Project Number ] & "*"

Now that makes a box pop up for the person to fill in specific information.

Now, is there a way to make a form that a user can choose a job from a drop down box, which then when click "next" it will execute a query with what was selected from the drop down box?

If anyone could help, id be very greatfull!

Thanks
~Jon

 

[freakazeud]

re:

Hi,
sure...just reference the combobox form control in the query criteria instead e.g.:

[Forms]![YourForm]![YourControl]

The form needs to be open at query run and the value you are trying to reference needs to be in the bound column of the combo.
HTH
Good luck