Modal Dialog Form

[Shallo9]

Good Morning All,

I am struck with a Modal Dialog Form..
Basically I've got a main form with a datasheet subform which is not editable which has a Primary key and a foreign key columns in it. The only way to add some data to this datasheet view form is by clickin' a cmd Button.

Once I click the button a Modal Dialog form appears and then the user selects or enters the details in it which then gets appended to the table.

I've made this Modal Dialog form to go to new record every time it loads but I am wondering if there is a way to link it to the main form I mean when I click the cmd button I want this modal form to appear but want the foreign key to be selected by default.

I hope I've managed to phrase my query properly.
Any help would be appreciated.

Many Thanks in advance.

 

[pbaldy]

One way would be to have the default property of the control on the modal form refer back to the main form.