By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,761 Members | 1,879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,761 IT Pros & Developers. It's quick & easy.

Trying to create an invoice form

P: 5
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?
Dec 27 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Dec 30 '07 #2

P: 5
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.
Jan 2 '08 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 2 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.