Select Record from list

[hootie318]

I have attached a picture for what I am trying to do. I have a list of names on the left in subform one. The detailed information on the right. I want to select a name in from the left and have the record information appear on the right. Can anyone point me in the right direction or link me to a sample db.

thanks

 

[JANR]

Just link recordID in subform 1 to recordID in subform2 in a master->Child relationship. See the property sheet of subform2.

 

[hootie318]

It says that I cannot link unbound forms.

 

[hootie318]

I accomplished my mission by using a listbox. Is there anyway to use my subform as a listbox?

 

[JANR]

It says that I cannot link unbound forms.

Yes you can, one way is to create an unbound textbox on your form call it txtID. On the properysheet of subform2 set link masterfield to txtID and childfield to your recordIDfield.

Now here is the trick, on the click event of your listboks use:

Private Sub mylistbox_Click()
Me.txtID = Me.mylistbox.Column(0)
End Sub

I asume that the recordID in your listbox is hidden in the first column. There is a bit of a delay but it will show what you're after, i've just testet it.

Ps hide txtID from view.

JR