Can anyone help please - I have a form with tabs on it and on each tab is a sub form
The problem I am having is making the combo box on one sub form requery when data is added on another sub form. It seems to work once when the main form is opened but will not work after that.
I have tried putting the requery command on just about every event I can find but it refuses to update the combo with new data.
If I refer to the 2nd sub form from the 1st I get the error "Cannot find the form"
I hope this makes sense - if not I will try and elborate
Thanks in advance
Peter

Peter

I'm working from memory here, so it may not be quite correct...

You cannot directly refer to a subform from a subform. You first have to go back up the tree to the parent form and then back down to the second subform - something like this:

Me.Parent.[Second SubForm COntrol Name].Form.cmbControlToUpdate.Requery

A simpler solution would be to assume that things have changed and requery the second subform whenever the user clicks on its tab.


Brian Skelton
Braxis Computer Services Ltd.

Thank you Brian
Worked very well
Regards
Peter:):)