Access 2007

[vauxv6]

Hi All

Can anyone help, I've been assigned a task to create a database within Access for storing parts. Each part is identofied by a part number (so far so good) what I want to try and achieve is a form screen (which can be opened from the switchboard) that ask for the part number and then once the enter button is clicked it opens the relevant form showing that part number and associated description, price etc.

What I cant do is work out how to create the search formula!!!

Any help greatly appreciated
:-)

[beso]

You haven't said how much you know about databases. Presumably you can make a table with the information.

Basically:

Create a form called "PartLookup"
Add a text box called "PartNumber" to the form.

Create a query based on the table and add the fields you want to see.
Set the PartNumber column Where: Forms!PartLookup.PartNumber

Add a Subform to the form.
Follow the wizard and select the query as its DataSource.

Set the Subform Default View property to Form.

Add the PartLookup form to the Switchboard.

Hope this helps.

[beso]

If you want to enter data into the form you need to "bind" it to the table.

Set the Record Source property of the main form as the table.
Set the following Properties of the Subform
Link Master Fields: PartNumber
LinkChild Fields: PartNumber

You can also set the properties of the subform that control which fields can be changed.

[vauxv6]

Thanks Beso that works a treat, you're a star