If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform Help
I created a form with two subforms on it and a combo box to search the
records. If I select a name in the combo box and minimize the form and then open each of the subforms they return the proper info. But when I open the form with both subforms included in the main form they are blank. I tried adding this to my combo's box Afterupdate - but I just get error message. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Me![cboComboSearch]) Me.Bookmark = rs.Bookmarkd adding this to the Afterupdate on my combo box Any Ideas ? |
#2
|
|||
|
|||
Subform Help
George,
Can you add the combobox to the Link Master Fields property of the subforms, and the corresponding field (looks like it might be ID) to the Link Child Fields property of the subforms? -- Steve Schapel, Microsoft Access MVP George wrote: I created a form with two subforms on it and a combo box to search the records. If I select a name in the combo box and minimize the form and then open each of the subforms they return the proper info. But when I open the form with both subforms included in the main form they are blank. I tried adding this to my combo's box Afterupdate - but I just get error message. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Me![cboComboSearch]) Me.Bookmark = rs.Bookmarkd adding this to the Afterupdate on my combo box Any Ideas ? |
Thread Tools | |
Display Modes | |
|
|