Form/Subform

[Guest]

I have a form with customer information. I have added a subform which has
purchase order information. Is there that when I search for a customer in
the main form, it will pull that customers purchase order information in the
subform simultaneously. Right now I have to search the customer on the main
form, then go down to the subform and search again for the correct purchase
order.

 

[Roger Carlson]

If there is a customer number in the recordsource for the subform, you
should link the mainform and subform on that. Look in the properties of the
subform *control* for Link Parent/Child fields.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "FormSubform.mdb" which illustrates this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Big Help!--Thanks! Website was helpful also!