My db has tblBrokerage, tblHedgeB. They share 9 columns. (Edit - I understand that duplicate data is terribel design however it is a client request for reference when completing the different user forms) tblBrokerage has a Form where users will enter data for tbl_Brokerage. It has a button I've been building a macro for to send data for the shared columns from the Form to the shared colulmns in tblHedgeB.
I imagine the correct steps to be:
1. create a local variable equal to the value of the txtBox containing the first shared column (Bnum)
2. open the table tblHedgeB
3. go to a new record
4. enter the variable value into the column for Bnum
I believe I have steps 1-3 completed but cant figure out step 4.
The steps I build are also just for 1 shared column, not 9, not sure how to approach that yet.
I imagine the correct steps to be:
1. create a local variable equal to the value of the txtBox containing the first shared column (Bnum)
2. open the table tblHedgeB
3. go to a new record
4. enter the variable value into the column for Bnum
I believe I have steps 1-3 completed but cant figure out step 4.
The steps I build are also just for 1 shared column, not 9, not sure how to approach that yet.
Last edited: