Unanswered: How do you update a query to a form instead of a datasheet?
How do you update a query to a form instead of a datasheet?
The query works OK on a onclick method but opens a datasheet view rather than going to the record in the form:
To elaborate: I have a table with serial number as primary key and a autonumber for the ID field. Ideally if I enter a serial number in the form that is already in the database, it would pull up the record that contains that value in the serial number field.
How do I make this happen. I'll admit I'm sort of a newbie.
I hope I am no over simplifying your problem. If I understand your question correctly you would want to build the form off of the query as opposed to the table. The Form Wizard will help you.
Just click new,
Choose form Wizard
in the drop down box choose your querey.
FI I read your post incorrectly please forgive me. If I read it right this should help you.