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!

Combo box for query selection help.

Status
Not open for further replies.

Gorphus

MIS
Nov 29, 2001
18
US
I have read several how-to's on having a query pull information from a form's combo box, and have not been able to get it to work. I have a form set up with just a combo box that is getting it's data from a table's combo box, which the user can add to. The form is working correctly, I can make my selection from it. However when I put "Forms!frmSystemType.cboSystemType" into the query criteria all I get is a text box with Forms!frmSystemType.cboSystemType as the decription. If I open the query up again it has as the criteria "[Forms]![Frequencies].[cboSystemName]". I am stumped. Let me know if you need any more information. Thanks in advance.
 
I think you need to add .value to the end of your criteria.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top