ReInput on the form

Topic

New Reply

Hi,

I would like to have a button call “ReInput” on the form to let user to delete all current data fields on the form, then user can reinput if they want. However, I couldn’t find a best codes to give to me what I want.

Thanks in advance.

Regards,

Reply | Quote

Replies

If I understand correctly your question, you should have two buttons. One to store all the data from the form and delete the record. he other button would be used to re-input the data on a existing or new form.
Is it that what you want ?
If yes, then use code for button 1 like this :
MyVariable1 = Me.Textbox1
MyVariable2 = Me.Textbox2
MyVariable3 = Me.Textbox3
…
DoCmd.RunCommand acCmdDeleteRecord

and for button 2
Me.textbox1 = MyVariable1
Me.textbox2 = MyVariable2
Me.textbox3 = MyVariable3
…

Variables should be declared at the top of the code so you can use them in both sub’s.

Reply | Quote

Hi,

I would like to have a button call “ReInput” on the form to let user to delete all current data fields on the form, then user can reinput if they want. However, I couldn’t find a best codes to give to me what I want.

Thanks in advance.

Regards,

Is the form bound to a table or query?
If so why not just execute:
Me.UnDo
this clears all the fields on the form.

Reply | Quote