open a new recordset on form

  • Thread starter Thread starter Eric Chen
  • Start date Start date
E

Eric Chen

does anyone can show me how to do with form control.
I like to open up a form each time with new record set,
and also within same form, I have a command button with
save record fuction, after click the save button will
save the record plus comes up with new recordset too.

can anyone help me out, please or show me some simple
file I could look up

thank you so much
 
new RECORDSET, or new RECORD? What are you trying to accomplish here?

You want a form that allows you to enter a new record into a table?


does anyone can show me how to do with form control.
I like to open up a form each time with new record set,
and also within same form, I have a command button with
save record fuction, after click the save button will
save the record plus comes up with new recordset too.

can anyone help me out, please or show me some simple
file I could look up

thank you so much
 
in the click event of the save button, enter following statement
as last line of code before End Sub:

RunCommand acCmdRecordsGoToNew

This will prepare the form for a new entry
(goes to a new record)

Krgrds,
Perry
 
I figure out myself, but thank you anyway.
-----Original Message-----
in the click event of the save button, enter following statement
as last line of code before End Sub:

RunCommand acCmdRecordsGoToNew

This will prepare the form for a new entry
(goes to a new record)

Krgrds,
Perry

"Eric Chen" <[email protected]> schreef in bericht



.
Click to expand...
 
Back
Top