Save record with form still open

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi,

Can anyone tell me why, even if I explicitely save (CTRL-
S) a record while in a form, when I look at the table, it
doesn't show the record until I move off the page or
close the form?

I am trying to open a second form from the first,
filtering on the autonumber of the first form. Do I have
to close the first form before opening the popup? I'm
getting one of those programming stiff necks on this one!

Thanks.
 
Hi,

Can anyone tell me why, even if I explicitely save (CTRL-
S) a record while in a form, when I look at the table, it
doesn't show the record until I move off the page or
close the form?

I am trying to open a second form from the first,
filtering on the autonumber of the first form. Do I have
to close the first form before opening the popup? I'm
getting one of those programming stiff necks on this one!

Thanks.
Click to expand...
Records are not saved until you close the form, go to another record,
click the record selector bar, or explicitly save it.

If you are opening the second form from a command button on the first
form:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "FormName" etc.
 
Back
Top