View Full Version : Display info in seperate fields


jds
05-25-2000, 03:53 PM
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
05-26-2000, 12:29 AM
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