Title doesn't make a lot of sense but here's the explanation.
FRM-All Properties contains subform FRM-Client Offers.
FRM-Client Offers contains a field named 'Offer Status'
On After Update of 'Offer Status' I have created a macro with an If statement that tells it to open the FRM-Initiate Contract if a particular status is selected in the Offer Status field.
Now, when the FRM-Initiate Contract shows itself based on parameters, the user has to select a name from a drop down and that initiates the contract, etc.
Everything works perfectly! Except....after the user has made the one selection, I need this form to go away and return the user right back to where he/she was before the Browse To opened the other form.
Please tell me there's a way! I just haven't found it yet. I'd really like to write it into the After Update event of the FRM-Initiate Contract in that once the user makes the selection it would close the FRM-Initiate Contract and return them back to where they were.
I don't know VB, so it will be no help there to tell me there's a code for that. I need something I can do with what Access offers.
Any ideas?
I've included screen shots. I haven't ever made a pop-up form but I could possibly figure that out and use that option instead, but this is just so nice to have the form suddenly appear right where you're at...if only you could then make it disappear!
Thanks for any suggestions, help, ideas!
FRM-All Properties contains subform FRM-Client Offers.
FRM-Client Offers contains a field named 'Offer Status'
On After Update of 'Offer Status' I have created a macro with an If statement that tells it to open the FRM-Initiate Contract if a particular status is selected in the Offer Status field.
Now, when the FRM-Initiate Contract shows itself based on parameters, the user has to select a name from a drop down and that initiates the contract, etc.
Everything works perfectly! Except....after the user has made the one selection, I need this form to go away and return the user right back to where he/she was before the Browse To opened the other form.
Please tell me there's a way! I just haven't found it yet. I'd really like to write it into the After Update event of the FRM-Initiate Contract in that once the user makes the selection it would close the FRM-Initiate Contract and return them back to where they were.
I don't know VB, so it will be no help there to tell me there's a code for that. I need something I can do with what Access offers.
Any ideas?
I've included screen shots. I haven't ever made a pop-up form but I could possibly figure that out and use that option instead, but this is just so nice to have the form suddenly appear right where you're at...if only you could then make it disappear!
Thanks for any suggestions, help, ideas!
Attachments
Last edited:
