data entry

[Greg Warren]

I have a database with several employees. I use an ID
number to log them into a restricted area. When they type
their ID number, how can I make the record automaticaly
come up? And if it is a new employee, let me add a new
record? I know I can use a combo box to pull the
individual records, but I also want it to default to the
next available record if they are not in the database
already.
Thanks
Greg

 

[Larry Daugherty]

Greg,

That would typically be done with a combobox with Autoexpand True and its
LimitToList property set to True. You need LimitToList True in order to
catch typos and new numbers. On a copy of the form you're already using,
with wizards enabled, put a new combobox in the header of the form. The
wizard will ask you what you want the combobox to do. Tell it "Find a
record ... ".

Look in Help for LimitToList. I believe it will get you going.

hth

-Larry-