Shop database - Seach options

[Simon]

I have a database for my online shop, I have a form that containers
deatils about order then i have a a subform in Datasheet what
containes the product on the order.

This works fine apart from now i have lots of products so unless i
know the product ID or the exact name it take me a long time to scrol
through all the product.

can any give me some better idea that gives be better seach funions
and easier/better way to add products

I was thinking of a button that will let me type a product name in
like ' Plates' then i can click search then it will show me all the
products with Plates in it then i can click on the correct product to
add to the customer order.

 

[John W. Vinson]

This works fine apart from now i have lots of products so unless i
know the product ID or the exact name it take me a long time to scrol
through all the product.

can any give me some better idea that gives be better seach funions
and easier/better way to add products

I was thinking of a button that will let me type a product name in
like ' Plates' then i can click search then it will show me all the
products with Plates in it then i can click on the correct product to
add to the customer order.

If the product names are logically arranged, you can use a Combo Box based on
the products table; it should store the product ID but display the product
name. No scrolling is required; you can just type the first few letters of the
product name and the combo will jump to the desired record.

If you want to get more elaborate, consider adding a Category ("plates") field
to the products table and use two combo boxes; the user would first select the
category and then use the second combo to select a product in that category.
See "Conditional Combos" in a Google search of this group, it's a very common
question.