Access - How to add records using subforms - TechRepublic
Question
June 12, 2007 at 07:17 AM
timothy_kramer

Access – How to add records using subforms

by timothy_kramer . Updated 16 years, 11 months ago

Here’s the quick of it:

1. I have a tblPOHeader and tblPODetail
2. I want the user to enter in purchase orders using a form that contains a fsubPOHeader in the Header of the form and fsubPODetail in the Detail section of the form
3. When entering data into the Header, certain fields should be populated into the Detail (Order Date, Request Ship Date, Promised Ship Date, Load Number, etc.)
4. When adding a new record in the header, the detail should be blank until data is entered.

I know this is kind of quick and just “thrown out there” like a grenade, but I was hoping to get an answer. Let me know if more information is needed. Thanks!

This discussion is locked

All Comments