G
Guest
Hi,
I have an access application that keeps track of people who sign up for
classes at a gym. There is a main form called BuildRoster that has drop down
boxes for things like instructor name and date and a subform called
AddToRoster that is continuous and has a drop down box for people who come in
for the classes. It is based on a query called CustomerQuery which is based
on a customer table. In addition, on the main form there is a button that
opens a form called AddCustomers that allows me to add names to the table.
So if a customer does not appear in my drop down list in the AddToRoster
form, I go to the AddCustomers form that allows me to add them. After I
close the AddCustomers form I am back at my main BuildRoster form and I click
on the drop down in the subform to select the name that I just entered.
However, they are not there. I have to actually close the entire BuildRoster
form and then reopen it. When I reopen it and click on the drop down in the
subform, the customer is there. Is there a way to get the customer to appear
in this drop down without having to close the form and go back in?
Thanks,
I have an access application that keeps track of people who sign up for
classes at a gym. There is a main form called BuildRoster that has drop down
boxes for things like instructor name and date and a subform called
AddToRoster that is continuous and has a drop down box for people who come in
for the classes. It is based on a query called CustomerQuery which is based
on a customer table. In addition, on the main form there is a button that
opens a form called AddCustomers that allows me to add names to the table.
So if a customer does not appear in my drop down list in the AddToRoster
form, I go to the AddCustomers form that allows me to add them. After I
close the AddCustomers form I am back at my main BuildRoster form and I click
on the drop down in the subform to select the name that I just entered.
However, they are not there. I have to actually close the entire BuildRoster
form and then reopen it. When I reopen it and click on the drop down in the
subform, the customer is there. Is there a way to get the customer to appear
in this drop down without having to close the form and go back in?
Thanks,