autopopulate field based on previous field in same table.

[bupinder]

i want my table to auto-fill a field based on the previous one.
the reason i want this to be done is so i can fetch data in a form from a single table instead of multiple, which creates record-source invalid/type mismatch error.

tblNames
ID


Name
Code
Desig
tblWork
ID
Work
Name(as in tblNames)(chosen by a combobox, dropdown)
Code(need this to autofill based on name, can fetch data from tblNames)

[June7]

Really should not save Name into tblWork, save the ID from tblNames.

Name is a reserved word and should not used reserved words as names for anything.

Properly designed and related tables should not cause type mismatch error.

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm