Simple criteria problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cant seem to get the query I run to select its criteria from the form Im
putting the comand button on. The criteria im using is
forms!Formsname!ContactID even though I have contactID ref on the form it
still asks me for ContactID Parameter.

I know its a simple solution, if you cold point me in the right direction.

Many Thanks

Paul
 
Paul said:
I cant seem to get the query I run to select its criteria from the
form Im putting the comand button on. The criteria im using is
forms!Formsname!ContactID even though I have contactID ref on the
form it still asks me for ContactID Parameter.

I know its a simple solution, if you cold point me in the right
direction.
Click to expand...

Are you sure the name of the control is "ContactID" or is it just bound to a
field named "ContactID"?

I always use the builder for this stuff so I know the syntax and spelling
will be correct.
 
I shall try that when i get home and see if it me being stupid, Ill let you
know in due time. Many thanks Rick!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where Not Exists 9
appending new records to a table with a compound primary key 9
Stop multiple IDs appearing in query 2
Need help with a combobox query 12
Count 16
Append/update Query with two sources 5
Creating a Msg Box for a certain condition 2
SELECT Statement 1

Back
Top