Refresh query/form

[iamthebestuk]

Hi,

I have a subform which I want to refresh/requery so it shows the most up-to-date value after I have made a change to a table it picks data from.

Currently I have the following line of code, which only works if there is already something in the subform (i.e. not blank):

Forms![frmSuc_Plan_JobSearch_Results]![frmSuc_Plan_Search_subform].Requery

I now need a piece of code to refresh the subform regardless of whether it has anything already in it.

Can anyone help please?

Bet regards,
iamthebestuk



Power is Knowledge
Knowledge is Power

 

[PHV]

You may try something like this:
With Forms![frmSuc_Plan_JobSearch_Results]![frmSuc_Plan_Search_subform].Form
.RecordSource = .RecordSource
End with

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[iamthebestuk]

PHV, that didn't work - it doesn't refresh the subform if it is empty to begin with. Only works if there is something in the subform already.

Do you have anymore advice?



Power is Knowledge
Knowledge is Power