Search Sub Form Help :)

[reecie24]

Hi there,

I know this question has probably been asked a million times, but for a n00b
it's kinda hard to find the time at work to search similar threads, so
apologies in advance!

I take my issue is quite basic, so here's the jist:

I currently have:

1 Table (data), 1 Add Form (fields are bound to the table), 1 Search Form (4
unbound fields) where by populating the fields with similar data captured in
the existing table and clicking the "Search" cmd button, a query is activated
and a new table pops up with the search results.

I require: a SubForm in the main Search Form (I would be adding all the Add
Form fields?), where by searching the unbound fields in the main Search Form
and clicking the "Search" cmd button, the SubForm populates with search
results of data from the table. Not necessarily one record, but I would like
many records to populate with related data from the search.

Any advice of stepping stones would be appreciated, thanks for your time!

 

[Jeanette Cunningham]

Here's a sample search form to do this without using a subform at all.
This will populate the main form with many records matching the search
terms.
You could put a subform on it if you wanted to.

The code has explanations for you to follow as you adapt the form for your
own database.

http://www.allenbrowne.com//ser-62.html

 

[reecie24 via AccessMonster.com]

Hi Jeanette,

Thanks very much for your time. The form looks simple enough to use, and I
shall modify to reflect what I am after.

Many thanks!

Here's a sample search form to do this without using a subform at all.
This will populate the main form with many records matching the search
terms.
You could put a subform on it if you wanted to.

The code has explanations for you to follow as you adapt the form for your
own database.

http://www.allenbrowne.com//ser-62.html

Hi there,

[quoted text clipped - 25 lines]

Any advice of stepping stones would be appreciated, thanks for your time!