C
Conner Stevens
I have a form (frmDataEntry) that has a combo box. The combo box pulls its
info from tlkpPhysName. tlkpPhysName has 3 fields lngPhysKey which is an
autonumber key and strLastName and strFirstName. When the user makes a
selection only the lngPhysKey (autonumber) value is saved to the table
(tblAdmDis) in field lngPhysName.
My question is this, I would like for the user to be able to add names from
the form and also save them to the lookup table. I've seen code that does
this, but not with 3 fields and an autonumber field.
Any suggestions?
Thanks.
info from tlkpPhysName. tlkpPhysName has 3 fields lngPhysKey which is an
autonumber key and strLastName and strFirstName. When the user makes a
selection only the lngPhysKey (autonumber) value is saved to the table
(tblAdmDis) in field lngPhysName.
My question is this, I would like for the user to be able to add names from
the form and also save them to the lookup table. I've seen code that does
this, but not with 3 fields and an autonumber field.
Any suggestions?
Thanks.