Macro/ VB Help - Refreshing data

[joolsUK0575]

Hi there

I have two forms in a database. One is the main form the other a sub-form.

On the subform I am running an append query.

My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data.

Can you tell me if there is anyway or anything that can be written in to a macro/VB to refresh the data. I have tried the RunCommand but this does not seem to work.

Any ideas?

Thanks

Jools

 

[NJudson]

After the query is run can you do a

DoCmd.Requery on the subform

If that doesn't work then try DoCmd.Refresh

Not sure if that's what you're looking for but that might help.

 

[joolsUK0575]

Hi there

Haven't gotten around to trying this yet, but to just to clarify.

When I press the button on the subform it needs to do the following:

1) run the append query, and then

2) refresh both the subform and the main form

Earlier on I experimented by putting a refresh button on the main form. After I had run the query I then pressed the button on the main form and it then refreshed and the data appeared.

Thanks for the help so far

Jools