I am using access 2000.
I have a form based on a table. in that form I have:
event name,event id, location, time
participant name, id, house
event & participant names are combo box. others text box.
when I select the event name the event id,time and location are displayed automatically (used an "on Change" event)
when Participant name is selected the house and their id is displayed like said above using the same method.
my probelm is that when I go back to see the data in the table, there's nothing in the following fields: event id, location, time, participant id, house <--these are the auto populating fields.
how do I get the details to be saved to the table?