Search form and invoice subform

[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.

 

[Michel Walsh]

A possible design would be with a main form and two subforms.

In the main form, have a control where you will type the part ID.

In one of the subform (controls in read only), have the 20 fields form the
table of Parts ID, and link the subform to the control in the main form
having the PartID.

Have the logic for PO, invoices, whatever, in the second sub-form. At first
glance, it seems you want to do a lot of very different things with a single
form... Can't you make one form per task, and use a menu (or contextual
menu) to help the end user to open the right form for the right task.



Hoping it may help,
Vanderghast, Access MVP