G
Guest
I am working on a database for my wife who is an independent hair dresser. I
am currently having some difficulties creating a way for her to track the
dyes and the amounts of dyes that she uses. I basically have one form for
appointments there is one subform on top which has the customer, date, time,
etc., and another subform below that on a tabbed control for the services.
On the other tabbed control I have a third subform which contains the dyes
for the services. On the dyes subform there is a combo box where she selects
what services she used the dyes on, I have changed the dye boxes criteria so
that it only shows the services that use dyes performed during that
appointment and it works great. The problem is that when she selects another
appointment in the top subform that combo box still only returns the dye
services from the first appointment selected. If you go to Records=>Refresh
it works fine, however I want it to happen automatically when another
appointment is clicked. I’ve tried seemingly endless variations of requery
in code, in all kinds of different places, any advice would be greatly
appreciated.
Thank you very much!
Adam
am currently having some difficulties creating a way for her to track the
dyes and the amounts of dyes that she uses. I basically have one form for
appointments there is one subform on top which has the customer, date, time,
etc., and another subform below that on a tabbed control for the services.
On the other tabbed control I have a third subform which contains the dyes
for the services. On the dyes subform there is a combo box where she selects
what services she used the dyes on, I have changed the dye boxes criteria so
that it only shows the services that use dyes performed during that
appointment and it works great. The problem is that when she selects another
appointment in the top subform that combo box still only returns the dye
services from the first appointment selected. If you go to Records=>Refresh
it works fine, however I want it to happen automatically when another
appointment is clicked. I’ve tried seemingly endless variations of requery
in code, in all kinds of different places, any advice would be greatly
appreciated.
Thank you very much!
Adam