Searching on subforms

[auger]

I have a form containing several subforms that are displayed as forms (not datasheets).

I can't search any of the subform fields and return results. Am I missing something? Is it possible to search fields on the subforms and return results and if so, how would I go about achieving that?

Thanks in advance.

 

[Guest_imported]

Try putting the form in design view, use a combo box from the toolbox(the wizard button should be on), the wizard will ask you which form and fields you want to lookup.(I hope this works, if not reply please!).
Good luck!

 

[Aivars]

Here is sample for searching data on subform by using combobox:

private sub cboComboBox_AfterUpdate()
dim rst as recordset

set rst=me.subFormName.form.recordsetclone
rst.findfirst "MyFieldName = " & me.cboComboBox 'Use valid separator for different data types, e.g.
"MyFieldName = '" & me.cboComboBox & "'" for text type and # for date type
if not rst.NoMatch then
me.subFormName.form.bookmark=rst.bookmark
else
msgbox "No data blablabla...."
end if
rst.close
set rst=nothing
end sub

Aivars |-0