microsoft.public.access.forms

On Oct 23, 2:28 pm, "Douglas J. Steele"
wrote:
> 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 MVPhttp://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?- Hide quoted text -
>
> - Show quoted text -

Thanks again, we're getting there. Only problem now is that the
actual underlying values in the table are changing too. So I can
click on a row in the list box and the sub-form values change but the
actual data is also changing. Is there a property I should be setting
somewhere to prevent this?

Thanks.