microsoft.public.access.forms

Sorry, I'm not sure I understand what you're asking.

Are you saying that you want the subform populated with details about the
item selected in the list box that's on the subform? You put code in the
list box's AfterUpdate event to take values from the list box and populate
text boxes on the form.

Private Sub MyListbox_AfterUpdate()

Me.Text1 = Me.MyListbox.Column(1)
Me.Text2 = Me.MyListbox.Column(2)

End Sub

That code would take the value in the 2nd column of the currently selected
row in the list box and put in into a control named Text1 on the same form,
and the value in the 3rd column and put it into a control named Text2. (The
Column collection starts numbering at 0. This technique will only work if
the list box's MultiSelect property is set to None.)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JWOL" wrote in message
news:1193145035.977036.190380@z24g2000prh.googlegroups.com...
>
> By the way, how do I then get the sub-form to show the new values of a
> record selected in the list box?
>