requery multiple forms ????

accesscomthomas

Registered User.
Local time
Tomorrow, 02:06
Joined
Jul 30, 2004
Messages
26
:confused: I'm having multiple forms working at the same time. All the forms contain a combobox to select "client" (limited to list). The idea is there's another form to manage the client information. However, I have no idea how to update all the combobox in other forms when I updated the client information.

1. how to update/requery the combobox of other forms when I edited the client information ? (I've tried requery but don't know why not working)

2. how to know if a form is opening or not ? (error comes when I try to requery a closed form). Because many forms contains that combobox to select client, I got to know which of them are opening

Tried for 3 days and give up now :mad:

Thanks for helping
 
:eek: oh !! the requery finally works (I had a wrong syntax of reference maybe). But the problem of knowing if a form is opening or not remains

Help plzzzz :confused:
 
If IsLoaded("Form1") Then
etc.
if you don't have the IsLoaded function you can find it in the Northwind db
 

Users who are viewing this thread

Back
Top Bottom