Form updates.

B

Bayou BoB

Hello Everyone,

Again lkely a simple question but it's driving me a little nuts.

I have my main client information page structured to include
"activities" that the client enjoys. There is a second table called
activities that holds a list of many activities to choose from...so
when people enter client information, they just select an activity
from a drop down box. Beside this drop down box though ,there is an
"add" activites button that opens up an activity form, and allows
users to edit that list, and add new activities not included on the
list. I would like any additions made to this table, to also refresh
the "activities" list in the combo box on the client form, which would
already be open if somebody hit the "add activity button". Currently
that's requiring a closing of the client form, and a reopen to get the
refreshed list of activites. How do I make this refresh happen
automatically when someone closes the "activities" list? Many advance
thanks.

Kevin
 
J

John Vinson

How do I make this refresh happen
automatically when someone closes the "activities" list?

Requery the combo box in the Activities list close code:

Forms!mainform!comboboxname.Requery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top