form field not saving 2 table

May 17, 2005 at 00:03:42
Specs: WinXP pro, 256

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?


See More: form field not saving 2 table

Report •

May 17, 2005 at 00:10:38

Have you added a "save" command button on the form?

And is your form only based on one table?

Report •

May 17, 2005 at 00:19:02

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?


Report •

May 17, 2005 at 04:56:24

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 ?

Report •

Related Solutions

May 17, 2005 at 14:54:26

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

Report •

May 17, 2005 at 16:32:29

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.

Report •

May 17, 2005 at 19:05:25

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.

Report •

Ask Question