CODEWITHSUNDEEP
sqlms-access
HelloWorld
HelloWorld

Reputation: 283

Access 2010 Me.Refresh/Me.Requery

I have a form that I want refreshed when the submit button is clicked. Preferably those that have default values will be restored and those without will be blank.

The submit button has an attached OnClick Macro that, checks to make sure all fields are filled, if so an action query runs that inserts a new row into a table.

So its after this action query that I want the refresh to occur. I have tried researching and come across suggestions that suggest using VBA code Me.Requery or Me.Refresh. I'm not 100% on how to incorporate this into the macro. The RunCode command doesn't recognize the function I put the code in, and The convert macro to VBA option in the top left is grey'd out.

I'm new to Access and just not seeing where the communications are for code and macros if someone could please elaborate for me I would be greatly appreciated.

Upvotes: 1

Views: 7147

Answers (2)

EastOfJupiter
EastOfJupiter

Reputation: 781

Please consider my solution as a brief introduction to VBA. If you care to learn the language, you will find there is very little you cannot do.

Within your submit button properties, there should be an 'Event' tab. In this tab, the On Click should be set to [Event Procedure]. Click the three dot button just to the right of that, and it will launch the VBA editor.

All you need to have here between the Private Sub and End Sub lines are these lines of code:

DoCmd.RunMacro ("Mac_1")
Me.TextBox1.Value = "Null"
Me.CombBox1.Value = "Null"
Me.Refresh

MsgBox "Your Save Was Successful.", vbOKOnly, "Saved"

"Mac_1" is the name of the macro you want to execute. the ME.Refresh executes as soon as mac_1 finishes, and will refresh the page. Be sure to enclose it in a proper quote (") and not a double tick ('').

Upvotes: 1

Benjamin Gale
Benjamin Gale

Reputation: 13177

The Requery command can be used from both within VBA code or a macro. It sounds like you are using the macro designer so you can use the Requery macro action instead of VBA.

Just add this to your macro after you have inserted your new data.

enter image description here

This macro action lets you specify a control to requery. The parameter can be left blank to requery the source of the active object. More information can be found here.

Edit

In response to your comments, I think you should try experimenting with the SetProperty macro action (more details here).

enter image description here

I have attached this macro to a button click event and the value from the TextBox called txtInputValue is cleared. The Value field is left blank as you want to fully remove the value from the text box.

Upvotes: 1

Related Questions