Forms question - saving a form - VBA

[joave]

Hi:

My form has several controls (options groups, text boxes, and a memo box)
that all are bound to my table. However, the only control information being
saved when I click my command button to execute the code is the memo field
and I cannot figure out why. All of the other fields save at the default
value. I have tried all of the following:

RunCommand acCmdSaveRecord
If Me.Dirty Then Me.Dirty = False
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

I am not officially connecting to the database through the VBA code - I
don't know if I have to and don't know how I would if I have to considering
all of the controls are already bound to the database. As stated, the record
is being saved, but the information is not right. Thank you in advance for
your help.

Dave

 

[Arvin Meyer MVP]

Usually, when that happens, only the default values are being entered. In
your case, I would check the form in design view and make sure that the
controls are actually bound to the underlying fields. If they are not, The
table defaults would be all that's saved.