Maybe there is a simple solution in what I am trying to do.

Background:

I have 3 Tables I am using:

Table 1:

MFGID-Primary key
Manufacturer
Address etc

Table 2: Parts
MFGID
PartNumber-Primary Key
Description
Price

Table 3: Order Details (No Key)
OrderNumber
PartNumber
(other details)

Problem #1
I am trying to make a form that can filter Parts by manufacturer. I have over 5k in parts among 7 manufacturers. I want to be able to have the MFGID ComboBox be the filter for the parts that are listed in the Part# Combobox while still autopopulating the "Description" and "Price".

Problem #2
How can I make it so that the field searches for items as they Type?

Problem #3
I want to be able to make it so that when they assign an order on one form the next form they open will have the order number already autopopulated in it-

Scenario

The user creates a quote. Quotes can have multiple orders. The user orders the parts but wants to adjust some of the information related to it located in Table 3. In order to adjust that information they need to pull up a different form than the Order Form. Since they had the Order form up I placed a command button to open the form to adjust the related information.

I want the new form to auto populate the order number from the first form.

I hope someone can help me. Sorry i am very new to Access so explain it to me simply.

Thanks!!

Okay, here is what you do:

Create a combo box using the wizard to look up the MFGID, Manufacturer in Table 1. Hide the PK column, unless your users use the MFGID number to look up the Man.

Then create a combo box to look up the PartNumer, Description, and MFGID. Hide the PK field, and the MFGID field as well.

Then open the query designer on the second combo box, and add this criteria to the MFGID field:

[Forms]![frmYourFormName].[cboMFGID]

Then on the After Update event of the first combo box, add this code:

Me.cboPartNumber.Requery

This will do the first part and synchronize the combo boxes. Then on the On Current event of the form, put this code:

Me.cboMFGID = Me.MFGID
Me.cboPartNumber.Requery

This will set the first one to the current record, and synchronize the second. When you scroll to a new record, they should go back to their start state. See if this throws an error.

This should take care of the first part.

mmcdonal