Synchronizing form interaction
-
Hi. My problem is i want to create a popup form to mimic a modal dialog that is created in MFC/C++. In Form1, i have a button that will open Form2. Form2 will be a generic "prompt" form that gets a user's response to a generic question (I want to reuse Form2 in other instances) and pass back values to the caller. Form2 will have: label text box command button for Ok command button for Cancel Example: (ask for an ID) Form1 caller will pass "Please supply an identifying name" to Form2 label. Form1 caller will user Form2 text box to do other work in Form1. Form1 will need to wait on (synchronize) Form2 for user to provide an answer. Form1 will then do processing on the response the user supplies. Problem: I don't know how to synchronize this sort of action in VBA. For the most part, the interaction between caller (Form1) and Form2 will be simple - show the prompt passed from caller and return the user's reply from Form2's text box. Thank you, John J M.
-
Hi. My problem is i want to create a popup form to mimic a modal dialog that is created in MFC/C++. In Form1, i have a button that will open Form2. Form2 will be a generic "prompt" form that gets a user's response to a generic question (I want to reuse Form2 in other instances) and pass back values to the caller. Form2 will have: label text box command button for Ok command button for Cancel Example: (ask for an ID) Form1 caller will pass "Please supply an identifying name" to Form2 label. Form1 caller will user Form2 text box to do other work in Form1. Form1 will need to wait on (synchronize) Form2 for user to provide an answer. Form1 will then do processing on the response the user supplies. Problem: I don't know how to synchronize this sort of action in VBA. For the most part, the interaction between caller (Form1) and Form2 will be simple - show the prompt passed from caller and return the user's reply from Form2's text box. Thank you, John J M.
I hate it when someone univotes a post with no explanation. You error is that this is a database forum and you are asking a question that requires VBA, I know you think you are using a database - Access but that is because Access should no longer be called a database, abomination maybe but not a database. You will get a much better response in the VB forum. You should also mention that you are using spit MS Access and the version as there are differences that may be critical. A possible answer - define some global variables representing the data, load them from the dataset/recordset or make the dataset/recordset a global. Sorry have not used Access for more than a decade.
Never underestimate the power of human stupidity RAH