Passing value to a subform

[RycherX]

I have a main form with a subform. On the main form, I have a list box with rows of data. When a user clicks on a row, I want the value that's bound to the list box get passed into a subform.

The subform allows the user to scroll through a table of records. However, I would like one of the fields in the subform to receive the value selected from the main form. Each time the user scrolls through the records in the subform, he must select the value from the listbox from the main form to populate the field in the subform.


I do not believe linking works in this case.

 

[vbaInet]

Create the form you wish to use as your subform and depending on how you want the view property to be, set it to Datasheet. Go back to your main form, draw a subform control on it, select that form you just created, then on the next screen select the fields identical to both the main form and subform