Not all controls in bound form writing to table

[oilman]

Hi all, I'm new to the forum and pretty green in the Access world. I am hoping for some input on a problem that has me stumped.

I have a form called "Test Entry" that has about 10 bound controls (both combo and text boxes) that write to their corresponding field in the table "Tests". I created an "on click" embedded macro tied to a command button as follows:

If [Form].[Dirty]
RunMenuCommand
Command SaveRecord
End If

Everything was working very well. I then added two new text box controls (txtStroke and txtSpeed) that are bound to their corresponding fields (Stroke and Speed) in the table "Tests". When I save the record using my command button, all my entries except for txtStroke and txtSpeed are saved to the table "Tests".

Obviously operator error, but I've looked and looked for any difference between my new text controls (txtStroke and txtSpeed) and the other text controls that are working properly but cannot find any differences.

Any thoughts?

Thanks.

 

[Pat Hartman]

If the columns aren't being saved, they aren't bound. Verify that the ControlSource of each contains the name of a column from the form's RecordSource and nothing else. If a ControlSource starts with an =, it is not bound, it is a "calculated" value.

If the ControlSources are correct, look for code that is clearing them prior to the save.

 

[oilman]

Thanks a bunch Pat, apparently somwhere in my additional code I was messing up the save record process. I now know how to track it down. Thanks again.