Forms

[Guest]

Hi all,
I'm trying to design a simple form for security guards to record vehicle
movements...
the table columns are; registration number, name, company, nature of
business, time in, time out...
The table is done but the form is giving me a headache. particularly the
"REGISTRATION NUMBER" combo box; when a vehicle that has visited before comes
again, and the guard starts typing the REG. I want the form to
"auto-complete" the rest of the details.... I know that sounds easy and
simple, but I don't work with Access enough to remember how... at the moment
if I enter the REG. access just says that the records don't match.... what am
I doing wrong?

 

[Jeff Boyce]

It sounds like you may be trying to have all the values added to a second
(third, ...) row, but I can be sure, because you haven't provided a lot of
description. When you say "auto-complete", do you mean to fill in (to the
form AND to the table) the same information as before? If so, DON'T!
Access is a relational database.

Once you've recorded the information one time, you can simply call it up.
You shouldn't need to re-record it.

 

[Penguin]

Yes with limit information the only thing I can see that is your Reg
Number does not change alone with name and company. This should be
stored in a seperate table. Create another table with an RecordID, Reg
Number, nature of business, time in, time out.

Now create a main form with a subform. The subform should be a
continous form based on the second tables data. Link the main form
with the subform via the Reg Number. Now everytime you select the Reg
Number from a combo on the main form it should bring up all data on
the vehicle. This should allow you to add additional data on the
subform.

Hope this helps