Save record with form still open

[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.

 

[fgutkind]

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.

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.

 

[Bonnie]

Thanks Fred, I think thats what I need. I'll go try it
out.