Display info in seperate fields

[jds]

I posted a message the other day and I'm sure if I explained my problem good enough. What I would like to do is select a name from a combo box, and within the form in different areas (not in the combo box) have the rest of that persons information displayed in seperate fields.(i.e. address field, phone #field, etc.) All of this information is on a seperate form already, I just need to get them to my main form. I hope I explained myself a bit better this time.

Thanx
JDS

 

[Mitch]

If the form has the table which you are searching as its record source, then you can use the combo box wizard to find a record based on the value selected, if not then create a query to be the record source, and access wil produce the code for you, which is...
Me.RecordsetClone.FindFirst "[txtSearchIn] = '" & Me![cboSearchFor] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

Hope this helps.

Mitch