Hi All,
Very beginner question here but I've never had need to do it before:
-I have two forms: Form 1 has a datagrid which contains say Primary Key
-Form 2 has a datagrid that has a foreign key linking to form 1's Primary key
-I am using a global variable to store the current form 1 primary key.
I want to be able to refresh the query on form 2 when form I selection is changed. I can do this on form two (ie. on load or a button) but can't activate the refresh from any other form.
Is there a way for this to be done?
Thanks,
J
Very beginner question here but I've never had need to do it before:
-I have two forms: Form 1 has a datagrid which contains say Primary Key
-Form 2 has a datagrid that has a foreign key linking to form 1's Primary key
-I am using a global variable to store the current form 1 primary key.
I want to be able to refresh the query on form 2 when form I selection is changed. I can do this on form two (ie. on load or a button) but can't activate the refresh from any other form.
Is there a way for this to be done?
Thanks,
J
Last edited: