Opening a form based on the transaction table

[prmitchell]

I wish to open a form based on the transaction table populate one of the foreign key fields with a selected value from a combo box from the switchboard (with going to a mainform&subform).
I know how to get the value of the combo box on the switchboard. I just know how to then store this value in the foreign key field.
stSelectedCustomer = Forms![Switchboard].[CustomerID]
gives me the value from the combo box on the switchboard
I then want to open the transaction form to open a new record and have Customer ID on this form be the stSelectedCustomer – storing this value in the transaction table when the user enters values in the other fields
Cross-fingers, thank you in anticipation

 

[Uncle Gizmo]

>>>I just know how to then store this value in the foreign key field.<<<

Did you mean to say:

I just WANT TO know how to then store this value in the foreign key field.

 

[bob fitz]

Perhaps some code in the forms Before Update event would do what you require but, what is your objection to using a main form/sub form arrangement.