T
Troy
I have a popup form in which I enter all my purchases. One of my fields is
Group. In Group I can choose what category (from a combo box) I want my
purchase to belong to. These are Maintenance, New Purchases, Upgrades, and
Conversion. When I close this form I am looking at my main form. On this
form I have 4 tab controls, one for each group. I tried using a make table
query to query my purchases table, one for each 4 groups. When I click on
one of the tabs I would like to see the updated changes that I entered on my
"purchases" form. I tried using the following code on the click event of
the form, but that didn't work. HELP!
stDocName = "Maintenance total"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Group. In Group I can choose what category (from a combo box) I want my
purchase to belong to. These are Maintenance, New Purchases, Upgrades, and
Conversion. When I close this form I am looking at my main form. On this
form I have 4 tab controls, one for each group. I tried using a make table
query to query my purchases table, one for each 4 groups. When I click on
one of the tabs I would like to see the updated changes that I entered on my
"purchases" form. I tried using the following code on the click event of
the form, but that didn't work. HELP!
stDocName = "Maintenance total"
DoCmd.OpenQuery stDocName, acNormal, acEdit