Search for Record Form for Main Form

[jhergert]

If you use frmStructuretoUnit, I have a double click event set up on the Structure Search combo box (unbound). When you double click on that it opens up frmStructureLookup. Once in frmStructureLookup, you can find a Structure Record and double click the StructureID and that will Transfer the Selected structure back to the unbound structure search combo box.

Once you have selected a structure from frmStructureLookup I would like to have that record brought up in frmStructuretoUnit. That is where i am hitting the wall.

Thank you for your help
josh

[Bob Fitz]

If you use frmStructuretoUnit, I have a double click event set up on the Structure Search combo box (unbound). When you double click on that it opens up frmStructureLookup. Once in frmStructureLookup, you can find a Structure Record and double click the StructureID and that will Transfer the Selected structure back to the unbound structure search combo box.

Once you have selected a structure from frmStructureLookup I would like to have that record brought up in frmStructuretoUnit. That is where i am hitting the wall.

Thank you for your help
josh

Like this?

[jhergert]

It doesn't seem to be updating the record in frmStructuretoUnit to match what is selected in the Structure Search Combo Box

[Bob Fitz]

It doesn't seem to be updating the record in frmStructuretoUnit to match what is selected in the Structure Search Combo Box

Are you sure? Seems to be working for me.

[Bob Fitz]

It doesn't seem to be updating the record in frmStructuretoUnit to match what is selected in the Structure Search Combo Box

Are you sure? Seems to be working for me.

EDIT:
Posted again in error

[Bob Fitz]

It doesn't seem to be updating the record in frmStructuretoUnit to match what is selected in the Structure Search Combo Box

Have you considered having another combo to allow selection of the description instead of using a popup form to make a selection. See attached db

[jhergert]

I downloaded the Sample 3 from your earlier post. Still doesn't seem to be working

[jhergert]

Sorry didn't see your previous post until after i posted. I am still very new to access. Learning as i go. For me i found it easier to set up specific searches on a continuous form. I like being able to see the results on a separate form and trying to transfer the selected result back to the parent form. I used Microsoft Dynamics at a previous Job and got used to the pop up form to search for records idea.

[Bob Fitz]

It doesn't seem to be updating the record in frmStructuretoUnit to match what is selected in the Structure Search Combo Box

Apologies. try the attached db

[jhergert]

Heavens no need to apologize. There are many ways to skin a cat. I appreciate yours and everyone's willingness for help.

I just tried it works perfect.

Thank you very much for your help.

[Bob Fitz]

Heavens no need to apologize. There are many ways to skin a cat. I appreciate yours and everyone's willingness for help.

I just tried it works perfect.

Thank you very much for your help.

You're welcome. Always pleased to help i I can

[Bob Fitz]

Heavens no need to apologize. There are many ways to skin a cat. I appreciate yours and everyone's willingness for help.

I just tried it works perfect.

Thank you very much for your help.

If we have provided a solution to you problem, please mark the thread as Solved. (can be found at the top of each thread by clicking "Thread Tools")