Using a modal form

[crowegreg]

I can't figure out how to pass the results from a modal form back to the original form.



Current this form, frm_PC_Log, is working properly. After opening the form, if you click on edit, an input box is displayed for the user to enter a search option. After making the selection, a combo box is displayed. After update of combo23, the record is displayed. This all works correctly.


I'd like to use the form frm_PC_Log_Search. I've tried commenting out everything related to the input box and the Select Case statements. If I open the form frm_PC_Log_Search, then make the selection, I can't figure out how to update the main form.


Within the attached DB, the form is working properly.

Thank you for your assistance!!

[mrojas]

I think what you need to do is use the following statement
DoCmd.OpenForm "frm_PC_log", , , "[FieldNameInFrm_PC_log]= '" & Me.[By Search Type] & '"" ' Assuming field is of text type

[crowegreg]

Thank you for the reply.

A couple of questions: Since frm_PC_log is the form that opened the modal form, it is still open. How do I work your suggestion into that? Also in the original code that works, when combo23 is updated, I have some code that takes place. How do I get that code to run?

[ItsMe]

You need to take your form out of modal if you are going to reference a control on another form.

Me.modal = false
dosomething here
Me.modal = True

[Missinglinq]

...You need to take your form out of modal if you are going to reference a control on another form...

Sorry, but that's not correct..

...Since frm_PC_log is the form that opened the modal form, it is still open...

Since frm_PC_log is Open, you can assign a Value from the Modal Search Form by placing this code in an appropriate event in the Modal Form:


Forms("frm_PC_log")!F1ControlName = Me.F2ControlName

or

Forms!frm_PC_log!F1ControlName = Me.F2ControlName

where

F1ControlName is the Control on frm_PC_log that you want the data assigned to

and

F2ControlName is the Control on the Modal Form that holds the data to be assigned back to frm_PC_log

Linq ;0)>

[crowegreg]

Thanks for the assistance. I'm nearly finished. A slight problem.

Originally, within form frm_PC_Log, after combo23 was updated, fields are displayed and populated.


Now, with adding your code to form frm_PC_Log_Search, I've added all the code that was in the event after combo23 updated to got focus combo23.


Within form frm_PC_Log_Search, I've set the focus to form frm_PC_Log combo23.


When executing, after going through all the code within got focus combo23, it returns to PC_Log_Search and gives an error of not able to set focus to combo23.


I've tried commenting out different lines of code, but I get the same results.

What do you think?

[crowegreg]

I figured it out. On the code that I had for afterupdate of comb23, I moved that to a sub, and I call the sub from form frm_PC_Log_Search.

Thanks again!!

[Missinglinq]

Glad you got it working!

Linq ;0)>