Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SubForm Horror!

Status
Not open for further replies.

sahaitu

Programmer
Jun 8, 2005
29
US
Greetings All:

I have a form named frmMain. I have a subform named frmDevExac. The parent form (frmMain) has four unbound combo boxes which draw information from four tables. The child form should be populated based on the selections in the parent.

I have linked both forms using the wizard. The child form is bound to the parent by the ID numbers for each combo boxes respective table.

When I select values from the combo boxes, the child form does not respond. I have built in a filter in the background of the main form.

Can someone help? Thanks in advance.
 
Try Me.Recalc or Me!frmDevExac.Form.Recalc in the AfterUpdate event of the combos.

Ken S.
 
Thank you though this did not work. Is there perhaps something wrong with the structure of my relationships or the bound columns for my combo boxes?

Thanks again in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top