Trying to create an invoice form

[mlb992000]

I am creating an invoice with a subform. I have a table with the vendor info and an invoice table. I am able to create a form that will pull up all the information on a particular vendor when I enter the vendor number.
I have a part table that has all the existing part numbers and the vendor numbers. I am able to create a query that will select all the part information for that vendor but I am unable to create the subform that will allow me to key a part number and then if the part number exist, the part information (price, discount and ext price) automatically populated the remaining fields.
Does anyone have a suggestion?

[nico5038]

Best to use a combobox that's filtering the (unique) customers.
Next design a subform for a customer on the main form.
Finally single click the subform and add under the Data tab of the properties window for the Master and Child linkage fields:
Master: Nam of your combobox
Child: Keyname of customer.

Same can be used for the parts...

Getting the idea ?

Nic;o)

[mlb992000]

I understand that I need to use a combobox that filters the (unique) part but
when you say make a combobox do you mean add a field to my existing parts table (that I created with only the parts for the selected vendor) and make it a combobox or do you mean create a combobox in my subform? Or do you mean make my part # field the combobox? I am a little confused.

[nico5038]

I understand that I need to use a combobox that filters the (unique) part but
when you say make a combobox do you mean add a field to my existing parts table (that I created with only the parts for the selected vendor) and make it a combobox or do you mean create a combobox in my subform? Or do you mean make my part # field the combobox? I am a little confused.

I described a combobox on the mainform that's "linked" to the subform.
Thus when selecting a part, the subform will show only those linked to the value (e.g. the vendor) from the combobox.

When you want to select first the vendor and then the part, you should read the Howto: http://www.thescripts.com/forum/thread605958.html

Nic;o)