Timing and controls on subform

[bri822]

I have two problems right now that I have no idea how to solve. My project works like this... You fill in required information on NewJob form. This form is a continous subform. And then you click in AddWorkOrder button on the subform. This opens up a new form to add a work order. On the Work Order form, you can either save it or cancel. The whole time the NewJob form is still open under the Work Order Page. I need to try to fill in a check box on whether or not the job has a work order.

I tried using subform controls, but that checked all the subforms. Now I am trying to edit the record and not the form itself. But right now I can not find any event that I could really use right now in order to run whatever code I can make to run my check. I tried almost all I could find, but no luck so far. I was wondering if there was an event that happened when I would close my second form on top of the open first form.

Also, I was trying to deactivate the AddWorkOrder button after it was clicked on the first time. My only problem is when I try to do this it ends up deactivating all my subform's AddWorkOrder buttons. So if anyone could help me change one control on a continious subform without changing all the subforms, that would be cool.

Thank you for any help!

Brian

PS. If I can clarify any more, please ask me and I will do my best to

 

[RichMorrison]

Brian,

Not sure I understand your situation, but maybe this will help.

You have a subform. The subform contains a command button. When you click the command button another form opens.

When you close the "other form", you want to update something on the subform. Specifically, the active occurrence of the subform.

If that's the way it is then you can:
open "other form" from code in an OnClick event in the subform,
open "other form" in dialog mode (see Access Help for details),
add a line of code after the OpenForm statement to update a control on the subform.

This works because when you open "other form" as a dialog, execution of code in the OnClick event of the subform is suspended until "other form" closes.

HTH,
RichM

 

[bri822]

Thank you

Mr. Morrison,

Thank you so much for that information. That was exactly what I needed!! I had been looking all over and could not find anything that would solve my problem till now. Thank you very much, you are a life saver.

Brian

 

[RichMorrison]

Brian,

You are welcome.

RichM