Good questions, Jim, thanks for helping me troubleshoot this. Sorry for the redundancy in the SQL, I just copy it from the SQL view and am afraid to mess with it mostly! The combo box data is text, here is my other query SQL that populates the combo box, there is only one column, I'm looking up the OrderNo from the same table with a few filters on the numbers. Should I also reference the column in the query criteria? I am really wanting the user to select the order from the form, then when they click the button, the query would append the record to a different table, and the click event takes them to a new form with that new record they selected. But I haven't gotten that far yet, stuck on this query reference! SELECT tbl_Master_Commitments.OrderNo FROM tbl_Master_Commitments GROUP BY tbl_Master_Commitments.OrderNo HAVING (((tbl_Master_Commitments.OrderNo) Like "4*" Or (tbl_Master_Commitments.OrderNo) Like "RK*" Or (tbl_Master_Commitments.OrderNo) Like "LC*")) ORDER BY tbl_Master_Commitments.OrderNo; Thank you, Cathy "Jim Pettit" <j_e_pettit@hotmail To: <mso@xxxxxxxxxxxxx> .com> Sent by: cc: mso-bounce@freelist s.org Subject: [mso] Re: Access 2002: Query Criteria Reference Not Working-Another 02/02/2005 08:18 PM Set Of Eyes? Please respond to mso ..... Cathy-- The SQL looks fine; distilled down with the redundant disambiguations removed, I got this: SELECT OrderNo FROM tbl_Master_Commitments WHERE OrderNo = [Forms]![frmSelectOrder]![cboOrders] So...since that part seems okay, I'm lead to believe that the problem rests with your data, and/or the way you're trying to get to it. What data type is in stored in the 'OrderNo' field? How are you populating the values in the 'cboOrders' control? And which column in that control contains the actual 'OrderNo' value that will be in 'tbl_Master_Commitments'? --Jim -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Cathy.Evans@xxxxxxxxx Sent: Wednesday, February 02, 2005 2:00 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Access 2002: Query Criteria Reference Not Working-Another Set Of Eyes? I am referencing the result of a combo box on a form in my query so I can append only that record. I use this type of form/combo box reference in many queries, but this time it is not working. I have checked spelling of form, combo box, etc., but not sure what I'm missing. Here is the SQL. When 'frmSelectOrder' is open, and combo box 'cboOrders' populated with a value, the query still comes up blank. When 'frmSelectOrder' is closed, I don't even get a parameter popup box when I run the query by itself. I have stared at this and re-worked it for 2 days, retyping the form and combo box name to make sure there were no typo's, and trying variations of the criteria, changing the '!' to '.', using 'Like [Forms]![frmSelectOrder]![cboOrders]', and any other variation I can think of. Anybody run into this or see what I'm missing? Appreciate any helps, thanks. SELECT tbl_Master_Commitments.OrderNo FROM tbl_Master_Commitments WHERE (((tbl_Master_Commitments.OrderNo)=[Forms]![frmSelectOrder]![cboOrders])); ----------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------------------------------------- ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************