Update all fields if a record already exsit?

[asabri]

Folks,
Is there an easy way to update the whole fields of a form after filling up one field of the record?
What I have is a main table.


and main form to add to the table items. That is working fine. However,
I want the user to be able to enter a value in any field and when it matches I want to load the other fields in the form with the proper values for that particular record.
I do have a unique ID for each record. If you know of any code or helpful MACRO in this forum please point me to it.
Thanks.

[hitesh_asrani_j]

Hi,

Have you tried using queries?

[asabri]

There is a query in each field that look on a sperate table for entries for that field and the combobox takes me to the field as I type. However, the rest of the fields don't upadte accordingly to the equivellant record. I am missing a mechanism to point the rest to the whole record I guess. I think you are recommending to place a query in each field ? if so what should be the logic within it?

[hitesh_asrani_j]

Any other criteria by which a user can search the record for?

[asabri]

Not sure. I guess the answer will be part of the solution I am looking for...