hi, 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? thnx.

Have you added a "save" command button on the form? And is your form only based on one table?

form is based on one table. the auto populating fields come from other tables. I am using dlookup function to match the data and display them. I need the displayed data to be saved to the table that the form is based on. as for the save button: no. but I do click the save icon. does that make any difference? thnx

sorry - using the save icon is the same as having a save command button are the fields in the auto populating table related to the main table ?

Ensure those autopopulating boxes are bound to the fields in the table (not unbound).

relationships exist between the tables used. If I get the fields bound to the fields in the respective tables, then the form fields display "#Name" instead of the value they are supposed to have looked up. no expressions or control source is used in the auto populate fields. all the work is done by event name and participant name fields which have "on change" code to auto populate the fields.

If you are getting #Name? when you bound the control to the field name then there is something wrong. That means it can not find the field name. Look at the control source for the form itself to make sure you included all the field names you want to update.