Problems with (If no data then) with user input

  • Thread starter Thread starter dennis.driscoll
  • Start date Start date
D

dennis.driscoll

Here goes!

I have a form that calls a query to supply the data for it; a unique
asset number. I have a function, placed in the "on open" event that
counts the number of records found, and displays a message if that
number is zero... easy enough. My problem starts when I have the
query ask for user input; ie the asset number. When I try to run the
form then, I get this error message:

The expression you entered as a query parameter produced this error:
'The object doesn't contain the Automation object 'Enter asset
number:'." <-- this being the query promt for the user to enter the
asset number to search for.

What do I need to do?
 
I would have the form collect the asset number and refer to the form control
value in the query. e.g.
[Forms]![FormName]![FormControl]

Dorian
 
Needles to say, I am new with Access... I have the query will the
form, because I am searching for a unique asset number. Once loaded, a
person can move it's lcoation, change it's status, etc... how can I
load the form first, then populate the form?
 
Back
Top