Query falsely recognizing procedure as data in criteria field

[Chad78]

Hello,

I am a very new user with limited knowledge mostly based on using Access 15 years ago (nothing since) and YouTube videos. I need help. I am trying to create a form with a combo box listing different contractors I would like to query and a command button that will create a report from that query. Doesn't seem too complicated. But Access seems to keep falsely recognizing the procedure as data in the criteria field of the query, as though it is one of the contractors I am trying to query. So of course when I go to my combo box on my form it lists no contractors. Here is the procedure: [Forms]![FrmContractor2]![ComboContractor]. From everything I have read or watched on YouTube it seems that I am doing it right. However, I may have some setting off that is not allowing procedures to run or something. Let me know if you have any suggestions. Thanks.



Chad78

[ranman256]

[Forms]![FrmContractor2]![ComboContractor] IS correct.

IF the combo has a value.
IF the combo is bound to the correct column that has a value for the field in your param.
ex: if combo value = 1 (the key) but the combo shows SMITH, and the contractor is a string for SMITH...the query will fail. If the contractor field is numeric (for key ID) then it will work.

[Chad78]

Gotcha. That makes sense. Let me give it a shot, which will take me a little while rebuilding a few things with how slow I am at this right now. Will let you know.

[Micron]

Just in case, the combo on your form is not bound to a query or table field, I hope. If you're using them for searching, they should have a row source but not a control source.