List Box Sub Form

[elfranzen]

Ok I have a list box in the main Form and when I double click on the information in that list box I want that information to be copied to the Subform.

I have tried something like this

Forms!MainForm!ComplaintAboutsubform.Form!ComplaintAboutNum = Me.List52.Column(0)

but this isn't right

Name of the main form = MainForm
Name of sub form = ComplaintAboutsubform
Name of control in sub for = ComplaintAboutNum
Name of list in main for = List52

 

[boblarson]

As long as ComplaintAboutsubform is the name of the subform CONTAINER which is housing the subform on the main form, then what you have SHOULD work. So, if the name is correct and it doesn't work then the next question would be is the list box's MULTI-SELECT set to yes? If so, you can't reference the value of the list box because the list box doesn't have a value when in multi-select.

 

[elfranzen]

I had a Space in the subform name so that is working now. But what if i want to make sure that a record has been started before they go into the subform. Were would I put the MSGBOX vb code to get this check for me.recordnumber is not null when they selected a subform field.