M
mikeinohio
I have a database that has 70,000 parts and what i have a form that has a
text box that when you type in the part number and hit enter it would
populate the other 20 fields of info related to that part and also i want to
put a subform on that page that will be attached ot the same table and or
query to do invoices, p.o.'s. qoutes, and packing slips from the same part
info, what i want to do in short is be able to search for a parts and create
invoices and stuff on the same form using fields from a customes query or
table to fill in the customer data automatically, and a subform to list the
part number and description and price my problem is i cant get the search
part to fill in all the fields and the subform to do what it needs.
text box that when you type in the part number and hit enter it would
populate the other 20 fields of info related to that part and also i want to
put a subform on that page that will be attached ot the same table and or
query to do invoices, p.o.'s. qoutes, and packing slips from the same part
info, what i want to do in short is be able to search for a parts and create
invoices and stuff on the same form using fields from a customes query or
table to fill in the customer data automatically, and a subform to list the
part number and description and price my problem is i cant get the search
part to fill in all the fields and the subform to do what it needs.