Refreshing Subform - Requery not working

[durdle]

Good day,

I have attached my db to simplify my explanation. When you open the db and in the Search field type "Tester", and then Click the Command button to the right on the next form. This will open the frmemployee form and on this form it has the "frmvachrsbooked subform" subform. There should be one record showing in this subform but it's not. But for some reason if you switch between Design View and then go back to Form View that one record shows up in the subform. I have search this site and used the requery and refresh options but they failed to work. Any help on this would be great.

thanks

durdle
________
114

 

[WindSailor]

Just a quick response... (I haven't downloaded your example)

Make sure all of your forms involved are bound forms. Bound to the relational sequence of the data you are trying to pull from in the subform, from tables, queries etc. And then ensure your master/child links and control items are correct if you want to requery your subform by another form.

Hope this helps.