Search for data on a subform?

[rasper22]

Hi!

I need to be able to search a subform while the the control is on the
main form. I have tried to place a combo box on the main form, but it
will only let me search the main form’s attributes.

Can some please help?


Franz

 

[John Vinson]

Hi!

I need to be able to search a subform while the the control is on the
main form. I have tried to place a combo box on the main form, but it
will only let me search the main form’s attributes.

Can some please help?


Franz

You're assuming - incorrectly - that a Subform contains data.

A Subform is a restricted window, showing that subset of the data in
the subform's recordsource Table which match the Master/Child Link
Fields. It doesn't contain any data itself and is therefore not
searchable; the data exists in the table, and only in the table.

If you want to search on a field in the subform's Table, how do you
want the mainform to synchronize with it? Suppose there are multiple
records in the Subform's table which match? What if they all refer to
different mainform records? Which mainform record would you want to
see?

This can be done... but it's usually confusing and difficult!

John W. Vinson[MVP]