Database search engine 1

[mercury1]

I have a database with the following fields:
Product, Vendor, Quantity, Mfr, Price & Date.

I would like to set up a form that let me search database and also enter new data.

The Product field has many of the same items with different Vendors.

I need to search database and have all the results appear in datasheet format so that I can see all results.

Thank you.

 

[SeeThru]

you probably want a custom form that sets the filter value for your main, datasheet view form [datasheet view is ugly BTW ;-) ]

Use a form which creates a valid 'Filter' for the datasheet, and then in code turn the filteron=true

To enter or deny new data, you can use the
DateEntry
AllowEdits
etc

setting them as you need them.