Having the Subform save a record even if it is Blank

G

Guest

Howdy from Oklahoma!!!

I am new to ACCESS and have a problem with a form/sub-form saving records.
I have a form (call it "FormA") that has a subform (call it SubB) from a
different table.

Sometimes Form A has data entered and not SubB but when I look at the tables
there is only a record for FormA and SubB does not generate a record. All
works fine if i add data to SubB but i want the form to build basically an
empty record if no data is entered. (this is because I am manipulating both
records later and if there is not a record for SubB then it errors out and
stops.)

So I am needing a way to make sure that a record is created for both the
Main form and the subform even if no data is input into the subform.

Any assistance would be greatly appreciated and as always THANKS IN ADVANCE!!!

Chip
 
R

ruralguy via AccessMonster.com

You will need to Change *something* in one of the fields in the SubForm so
the record get Dirty and Access will save it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top