S ssmith001 Registered User. Local time Yesterday, 20:53 Joined Jun 6, 2006 Messages 29 Feb 6, 2007 #1 I have a form with a combobox called fraShipDay. How do I reference the value of the user's selection in a query? I've tried using Forms![Form1]![fraShipDay] but it's not working.
I have a form with a combobox called fraShipDay. How do I reference the value of the user's selection in a query? I've tried using Forms![Form1]![fraShipDay] but it's not working.
M MStef Registered User. Local time Today, 04:53 Joined Oct 28, 2004 Messages 2,250 Feb 7, 2007 #2 What is the name of your form??
Wiz47 Learning by inches ... Local time Yesterday, 23:53 Joined Nov 30, 2006 Messages 274 Feb 7, 2007 #3 Code: WHERE yourfieldName = Forms!YourFormName!YourComboBoxName is the correct syntax - so it should work - as long as you have referenced the right form and the right combobox.
Code: WHERE yourfieldName = Forms!YourFormName!YourComboBoxName is the correct syntax - so it should work - as long as you have referenced the right form and the right combobox.
