CHANGING SUBFORM IN ONE FORM????? (1 Viewer)

[bendiver]

HERE IS MY PROBLEM I HOPE I CAN GET HELP! I HAVE AN INVOICE SCREEN FORM WITH A SUBFORM SHOWING THE DETAILS OF THE INVOICE. WHAT I NEED TO DO IS CHANGE WHICH SUBFORM OUT OF EIGHT BASED ON QUERIES ARE SHOWN ON THIS INVOICE DETAILS SUBFORM ZONE DEPENDING ON WHAT BUTTON IS SELECTED IN THE MAIN INVOICE FORM. FOR EXAMPLE CLICKING THE SALES BUTTON WILL SHOW THE SALES SUBFORM BASED ON THE INVOICE DETAIL QUERY. I AM USING ACESS 2000 IF THAT MEANS ANYTHING.

THANKS IN ADVANCE

 

[KeaganQuilty]

What you need to do it to change the SourceObject of the subformbox to the name of whichever form you want displayed as the subform.

I hope this is what you meant. I had trouble reading the AllCaps

Keagan Quilty
Kilbride, Newfoundland