Pop Up Form to Add Related Records

K

Kirk P.

I've got 4 tables, tblCustomer, tblProduct and tblData. The 4th table is a
"junction" table (tblCust_ProdRate). The primary key of this table is CustID
and ProdID. The purpose of tblData is to store the transaction date and
number of subscribers for each CustID and ProdID.

I've got a form/subform (frmCustomer/sfrmProdRate) that displays all the
customers, the products sold to them, and the rates associated with the
product and customer. In the subform, I've got a command button displayed
with each product that the user can click to bring up a pop-up form
(frmTrans) to display and enter the transaction details in tblData such as
the transaction date and number of subscribers. I need this pop-up form to
display the CustID and ProdID associated with the form/subform, but thus far
I can't get it to work.

I've been messing around with the Form_Open event in frmTrans to mess around
with the default value, but I don't know how to modify that to display BOTH
CustID and ProdID. I'm not even sure if the default value is the right thing
to modify. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form design to add data to 3 tables in "Order Entry" style db 1
Form Data Entry Problem 1
cascading combos form to subform help 0
DLookup Dilemma 0
write conflict for junction table - many to many 0
Last Record On A Continuous Form (Problem)... 2
Design of a simple sales entry database form 3
Open pop up form problem 4

Top