How can I create a 'Custom Find Field dialog/form' for a SubForm?

[efandango]

I have a sub form with 16 separate fields.

I want to create a text search form where users can type the name or address
into it and go to the record page on the subform.

I tried using the Combo Box Wizard with its ‘Find a record based on the
Value I select in my Combo Box’, as a starting point, with a view to tweaking
it as a standard text box, but that wizard doesn’t give the ‘Find a record…’
option for the subform.

How can I go about creating this kind of feature?

 

[rkresnadi]

Are you familiar with vba for access?

if you do, there's a way to call access's find record built in function. I
believe it's called runcommand something. find in help file about runcommand
function.

if you don't know vba, then you can try to create a query that uses your
combo box as the criteria in that query. then display that query in the
subform.

Restu Kresnadi