Re: make a field value a condition for select to populate rest of form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Dec 27, 12:21 pm, Minton M <jamesbesw...@xxxxxxxxx> wrote:
On Dec 27, 9:06 am,EdStevens<quetico_...@xxxxxxxxx> wrote:

Given a form with 3 fields:

ssn
firstname
lastname

Currently, data source for the form is a table, 'emp'. So when we
open the form we can scroll through each of the rows in emp. We need
to be able to enter a value in ssn and use that value to query emp to
populate the other two fields.

One simple way would be to use a combo box with a rowsource set to
this table and ssn as the first field. As you type the ssn, it will
match the rest of the record. Alternatively, just have the ssn in the
combo and use it to filter the records on the underlying form (use
this method if you need to edit the other field).

-- James

James,

Thanks for the reply. Unfortunately, neither of us are very
conversant with Access, so need a little more detailed explanation.
Yes, we will need to edit the other fields, so the second solution
would be what we want. So... exactly how do we use the value of the
combo box to filter the records?
.

Relevant Pages