Recent content by andygp40

Thanks for this. Think we've cracked it though- see "please put me out of my misery" thread for details.

I've added Forms!YourMainFormName.YourSubFormName.Form.YourComboBoxName.Requery to both the event "On Current" on the form and to the "On Change" event on the Club Id field. It now seems to work as expected. Thank you ever so much! I shall sleep now. Regards Andy

I'm afraid you lost me there. I added the Forms!YourMainFormName.YourSubFormName.Form.YourComboBoxName.Requery reference and the Combo Box now requeries. Thank you. I think though I need to go a step further and identify the other events when the Club Id changes as when I update or insert a...

Progress! Oh deep joy! Sanity almost restored. As I scroll through the mainform the combo box changes. Fantastic!! A couple of little additions. If I change the club or add a new team, the combo box doesn't work yet. I guess I should repeat this on some other events. Would you please...

Tried Forms!MainForm.MemberNo.Requery and Forms!SubForm.MemberNo.Requery without success. Please help a fool who is slowly going mad with this!

Please confirm - "YourFormName" is the name of the subform. Thanks

Still struggling, I'm afraid. Tried Requery on the mainform, but the Combo box isn't known. Tried on the subform and no success. Have I missed the obvious?

I have a form that displays a Club's Teams, e.g. each of the football teams or badminton teams. A sub-form then shows all the members of the team - the squad. The first field of the sub-form is a combo box that attempts to only show the members of a club. The combo box populates fine...

I have a combo box on a subform that is based on a parameterised query. The parameter is passed from the main form. The combo box populates initially but doesn't repopulate to reflect the change of parameter on the main form. I have tried to Requery on Enter but get hit with a "You can't...