Form not saving back to table

[Christine Jackson]

I have a number of tables (all linked through relationships) containing information relating to vehicles, employees etc.

I created a form for the input of new information in relation to the taxation relating to the vehicles. This table has a record no as its unique code as the primary from the 2 main tables can be duplicated more than once in the P11D table/form. In this form I have some DLookups to bring in data from one or more of the other tables, and I also have calculations within the form, to work out Cash Equivalent, Number of Days not allowed etc.

In the form it all works brilliantly, just as I want it to, but for some reason its not saving back to the table meaning that I am unable to run any queries or reports.

Anyone any ideas where I have gone wrong? Would appreciate any feedback, and if anyone can help, can you explain as if to a 5 year old. Still a relatively new user to Access and mostly self taught so struggle with a lot of the technical jargon.

Many thanks

Chris

 

[Yeldarb]

Do you have unbound fields in your form that are making calculations?

This could be why the data is not reaching your tables

 

[Christine Jackson]

Unbound? Sorry, I'm really dense I know, but not sure what unbound fields are. What are they and if I do have them, do I bind them!! and do you think that will sort my problem.

Sorry, appreciate your help though.

Chris

 

[Yeldarb]

No worries.

In the design view of your form, when you look at the text part of your field, Does it say Unbound?

In other words, is the data you want to show in your table, linked back to your table?

 

[missinglinq]

In Form Design View, Right Click on a Control whose data is not being saved back to the Table then Click on Properties - Data. What appears in the Control Source Property? It should be the appropriate Field in the underlying Table.

FYI, Calculated Fields should not be saved in Tables; instead they should be re-calculated whenever they are needed.

Linq ;0)>