Question How i create a Save Button and A Clear Form Button?

[Amenofhis]

Thanks to vbaInet

i manage to get the list of user and names, and after that my friend ask me to make a Save and Clear Button i try to do it using the Wizard button, It doesn't work at all, after i made the button the list didnt appear and the name also didnt show.

Also i want to make it step by step because every time i hit enter start to jump from a text box to another without doing it in order. i want to do it like a letter
first stop then start going down untill u hit the save button. and it do the opposite

 

[The_Doc_Man]

I'm either being dense or you didn't explain this question fully.

Please give us a little more detail in where you start and what you need to produce.

Let me add that if the form is bound, the wizard should be able to make a SAVE button pretty much in its sleep. But if a form is unbound, there is technically nothing to save from the Access point of view. It would make sense that the wizard would be lost. So please clarify your context.

 

[Amenofhis]

actually its bound and working very good actually

 

[ghudson]

Command to save the current record...

DoCmd.RunCommand acCmdSaveRecord

Command to clear a text box...

Me.YourTextBoxNameHere = Null

or

Me.YourTextBoxNameHere = ""

 

[smoses]

Command to save the current record...

DoCmd.RunCommand acCmdSaveRecord

Command to clear a text box...

Me.YourTextBoxNameHere = Null

or

Me.YourTextBoxNameHere = ""

Hi there, I have tried this Me.YourTextBoxNameHere = "" and it actually deletes the record from my table instead of just clearing the form. What am I doing wrong? Also, how do I set the form to open up blank instead of filling in something from the table? Sorry, been a long time since I had to build a new DB. Thanks.

 

[Adam Caramon]

Hi there, I have tried this Me.YourTextBoxNameHere = "" and it actually deletes the record from my table instead of just clearing the form.

A bound form displays a record from the table. If your textbox is displaying a field from your table, and then you set the textbox to "", that will set the field of the bound table to "". Maybe you could explain what exactly you mean by "clearing the form". Do you want to move to a blank record?

Also, how do I set the form to open up blank instead of filling in something from the table? Sorry, been a long time since I had to build a new DB. Thanks.

DoCmd.GoToRecord , , acNewRec

I put that into my Form_Load event.

 

[smoses]

A bound form displays a record from the table. If your textbox is displaying a field from your table, and then you set the textbox to "", that will set the field of the bound table to "". Maybe you could explain what exactly you mean by "clearing the form". Do you want to move to a blank record?

Yes, I want to move to a blank record. Or if I typed an error then click the clear form and start over.

 

[Adam Caramon]

Take a look at the data entry setting:

http://office.microsoft.com/en-us/access-help/dataentry-property-HA001232728.aspx

If you use the form only for data entry, this is probably the way to go.

 

[smoses]

Actually I found that link just before I read this reply! Thanks for your help, I appreciate it.