You need to know when you've returned from a secondary form, and which
comboboxes that secondary form affects. Upon return to the main form,
you'll have to cause the affected comboboxes to be reloaded.
If you're using Data objects, one for each combobox, then just use the
appropriate data objects' .Refresh method. If you're manually loading the
comboboxes, then re-run the routine that loads them. If the latter is the
case, you might want to consider splitting the routine that loads comboboxes
into several routines, one for each set of comboboxes that can be affected
by a secondary form. That way, when you return from a secondary form, you
can run the routine that reloads just those comboboxes that might have
changed, and not suffer the overhead of reloading ALL the comboboxes.
Pete
-----Original Message-----
From: David [mailto:netdaviso@h...]
Sent: Thursday, February 27, 2003 1:41 PM
To: professional vb
Subject: [pro_vb] RE: check file
Can you help me???
I have, in Access 2000 a main form. A couple of button that open secondary
forms. Well. In the main form I have a few ComboBox that retrieve data
from
a table. In the secondary forms I update this tables. When I close the
secondary form I want in the main form appear in the ComboBox the new data.
Everybody talk about requery, refresh, and so on. But I cant make it work.
Maybe if you want, I can send you a litle copy.
Well, any help will be good for me.
Thanks