Having problems with sub forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I seem to always have this problem. I have a form that the user selects items from different tables and enters them into another table. I have a sub form on the main form that I want to show the items as the user selects them. After the user selects the item they click a button to add to order, at that time I want the item to show up in the sub form. The forms are linked by ordernumber. I've tried the refresh, recal, repaint and just about everything but nothing seems to work. Any help would be appreciated

Thanks
 
I assume you are selecting an item from a combo box and
you want related records to appear in the sub form. If
that's the case in the AfterUpdate event of the Combo Box
try

Me.SubFormName.Requery

-----Original Message-----
I seem to always have this problem. I have a form that
Click to expand...
the user selects items from different tables and enters
them into another table. I have a sub form on the main
form that I want to show the items as the user selects
them. After the user selects the item they click a
button to add to order, at that time I want the item to
show up in the sub form. The forms are linked by
ordernumber. I've tried the refresh, recal, repaint and
just about everything but nothing seems to work. Any
help would be appreciated.
 
Back
Top