Create a form with the fields you want to display.  Create a query that
returns all records for the form.

On the form, add an unbound combobox that lists part numbers.  The Header is
a good location.

Modify the query to look at the form's combobox as a selection criterion for
the part number field.  This will look something like:

   Forms!YourFormName!cboYourComboboxName

In the combobox's AfterUpdate event, add something like:

   Me.Requery

(this will cause the form to recheck its source, the query, which uses the
combobox selection to return a single record)

It that what you are trying to do?

Regards

Jeff Boyce

Microsoft Office/Access MVP

One way you could do this would be to have some/all of your additional
fields in your combo box row source (like PartNo, Desc, Cost, Markup, Sell
Price, etc.) and in the AfterUpdate event of the combo box, you could then
fill your other fields in based on the contents of the columns of the
selected part in the combo box.

me.description = Me.cboPartNo.Column(2)
me.cost = Me.cboPartNo.Column(3)
...
hth

John