create search form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhetta75069 - 20 Oct 2005 19:31 GMT

How do you create a form that will search for items and display them in
datasheet view in a subform? I have a table that has lots of data regarding
orders. I want to be able to search via a PO number, Manufacture location
etc and the records populate in a subform.

Reply to this Message

MacDermott - 21 Oct 2005 02:23 GMT

Look at the FilterByForm option...

> How do you create a form that will search for items and display them in
> datasheet view in a subform? I have a table that has lots of data regarding
> orders. I want to be able to search via a PO number, Manufacture location
> etc and the records populate in a subform.

Reply to this Message

Rhetta75069 - 21 Oct 2005 13:57 GMT

How do I tie the subform to the main form so that when I search for the data
I need, it will populate in the subform?

> Look at the FilterByForm option...
>
[quoted text clipped - 3 lines]
> > orders. I want to be able to search via a PO number, Manufacture location
> > etc and the records populate in a subform.

Reply to this Message

Duane Hookom - 21 Oct 2005 03:24 GMT

The is a query by form applet that you can import into your mdb that
performs this function and more. It's a free download at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Signature

Duane Hookom
MS Access MVP

> How do you create a form that will search for items and display them in
> datasheet view in a subform? I have a table that has lots of data
> regarding
> orders. I want to be able to search via a PO number, Manufacture location
> etc and the records populate in a subform.

Reply to this Message

Rhetta75069 - 21 Oct 2005 13:29 GMT

So all I do is copy and paste this applet into my access database? How do I
edit it to work with my data?

> The is a query by form applet that you can import into your mdb that
> performs this function and more. It's a free download at
[quoted text clipped - 5 lines]
> > orders. I want to be able to search via a PO number, Manufacture location
> > etc and the records populate in a subform.

Reply to this Message

Duane Hookom - 22 Oct 2005 04:29 GMT

There are instructions on the main form of the applet if you just open it.
You import the objects as noted on the form. Then, all you need to do is
clear out the sample data from qbf tables and create your own master
queries. These need to be saved with a name beginning with "<".

Signature

Duane Hookom
MS Access MVP

> So all I do is copy and paste this applet into my access database? How do
> I
[quoted text clipped - 10 lines]
>> > location
>> > etc and the records populate in a subform.

Reply to this Message