Pop up window with search field

[Nishikawa]

Hi,

I have created a typical form (Form A) that shows data from a table. I also created a combo box within the form that searches for records. Within the form itself, it searches and display the record smoothly.

I created another form (Form B), showing all details of another table, inclusive of the primary key.

I made Form A as a pop-up window to Form B. When I clicked on the primary key in Form B, Form A pops up with the corresponding data related to the primary key in Form B (I used the primary key as the string criteria),

The problem starts when I trying clicking on the combo box to search for a different record within Form A itself.

Can anyone help me in this?

 

[boblarson]

The problem starts when I trying clicking on the combo box to search for a different record within Form A itself.

What's the problem? If you add a combo box to the form, using the wizard, you get the option of selecting a record based on the selection in the combo box. The wizard should set it up for you.

 

[Nishikawa]

Yup it does. It works perfectly fine if you just click it on the form (on it's own.) The problem starts when that form becomes a pop up window of another form. The combo box no longer works and I just cannot figure out why.

I tried changing "Me.Recordset.clone" to "Forms!XXX! Recordset. clone" and rs.findfirst "WW = Forms!XX!YY!WW" but it still does not work.