Query used in form?

[Tech]

Hi there.

I am working on a group project and need help ASAP with every detail please.

I am making the Database for a company (imaginary!) which is to computise their system. Right, I got the order form, now I need to put in the product details form etc..

the thing is that, I want it when the user enters an order number OR description, all the details about that product should appear. Is it possible to do this? If so, how?

Also, can we place this query/information on a form and from there, if the user enters a product number/description, the behaviour should be the same?

PLEASE..I NEED HELP!! I am going nuts and this is suppose to be in the next 2 weeks, and we only got it last week!

I am trying so hard but can't remember some stuff and some stuff, like this, I have never done.

I have done the paperwork etc.. but this pratical is remaining.

Please help,

Thank-you in advanced

 

[ColinEssex]

Use a ComboBox. Create it with the wizard and select the 3rd option.

Col

 

[Tech]

Thanks but I prefer to have it like, the user types in the product number in a text box and all the appropriate info comes up..is it possible?

So, all I have now:

a Product table in the query with the fields:

Product number
Description
Finish
Room
Unit price
Number in stock

so, what do I do now? Just save this query (without any criterias), create a form based on the query and put it in a subform in the order table and it should work?