Storing combo box data to tables (1 Viewer)

Data Slave

New member
Local time
Today, 00:17
Joined
Feb 22, 2000
Messages
9
i'm having a problem storing the data from my combo box onto the appropriate table. which property is this on the list of properties for the combo box? right now it is storing the autonumber(ID#) instead of the name associate with the number. does this have to do with the row source? i need to fix this in order to print reports and store the data on tables more easily. thanks for your time & help.
Data Slave.
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 19:17
Joined
Feb 19, 2002
Messages
43,257
No, you really should store the ID#. To display the descritption in a query, add the lookup table and create a left join to it. Then select the description field.
 

Users who are viewing this thread

Top Bottom