Refresh unbound table

[fhickler]

Is there a way to click a button on an unbound form and have it execute the eqivalent of the refresh command on an unbound table? I anticipate people saying that this is bad practice, or ask for more details in order to advise me of a different way to do it. But first I want to find out if this is possible and if so, what the code or macro would be that would be that would be associated with the button.

[CJ_London]

the way you refresh a form is

me.requery
alternatively
me.refresh, me.recalc or me.repaint

whether one of these will do what you want, I wouldn't know, try them and see

[rpeare]

What are you doing on your unbound form?

If, when you open your form, it is displaying the values relating to a specific record and someone subsequent to your opening the record changes the data and you want to refresh the page to see if the information is still current, then yes, you just call the 'on open' event of the form from a button click and it should repopulate the form.

[davegri]

If a form is unbound, some action (VBA or macro) must be taken to retrieve data from a table to display on the form. A refresh or requery emulation for such a form would simply require a button for example, to run the code that populates the form.

[fhickler]

I think I figured it out. Basically I have a form with a button that, when clicked, writes some data to a separate table via VBA. The form and table have no relationship other than that. So I want the table to refresh everytime the button is clicked so I don't have to manually. I found a code snippet that seems to work:

DoCmd.SelectObject acTable, "tblAudit"
DoCmd.Requery

Thanks for trying to answer my not very detailed question.

[davegri]

Ah, so you wanted the data to show everywhere else once the unbound form updated the table...
Glad you figured it out.

[pbaldy]

Is the table open or something? It doesn't make any sense to requery the table otherwise; you'd requery the form/report displaying its data. If the table is open, I'll point out that most of us do not let users into tables or queries directly, only forms and reports. You have little control over what they do otherwise.