HOW!

  • Thread starter Thread starter Melisand
  • Start date Start date
M

Melisand

Having created a DB with tables and form to imput info in
to this, I would like to be able to open the form at blank
record, (which I can do) but when tping in the first few
letters of a record name want the rest of the record to
appear in relative boxes on the form so I can make
updates. Instead of having to scroll through all the
records to get to the one I need to update. Any help would
be greatfully recieved. K
 
Melisand,
The fields on your "blank" form are for entering New records, not for
locating records particular records in your database

If you have a key field that uniquely identifies any particular record,
you can set up a combo box on your form that displays all those values, and
when the user selects a value, goes to that unique record. I usually put
this "Find" combo box in the upper right corner of the form... out of the
way, but still available

Use the AfterUpdate event of the combo to do a FindRecord using the value
selected in the combo.
hth
Al Camp
 
Back
Top