Subform not updating

[matthewnsarah07]

Main form = frmmain
Sub form = frmmainsub

I have two fields on the main form & [User] that are populated using the on open event for the main form. User is based on a table and is populated by the GetUser function

The subform is based on qryleaveview which uses field [Email] to filter the data, however when I open the main form there are no records in the subform - I know this must be to do with the fact that the field [email] is populated on open but how do i rectify this?

Thanks

 

[pbaldy]

Have you tried a requery of the subform after populating the values?

 

[matthewnsarah07]

I thought of that but I've not used that function before, is it:

DoCmd.Requery? would it be best to add this to the on load event of the main form?

Thanks for your help

 

[pbaldy]

Try something like

Me.SubformControlName.Form.Requery

 

[Willem!]

No, use in the MAIN form:

Me.frmmainsub.Requery

HTH

 

[Willem!]

Try something like

Me.SubformControlName.Form.Requery

...even better...

 

[matthewnsarah07]

Thanks both for your help - place the requery in the on load of the main form and works a treat