Combo Box

[Janie]

Is it possible to use a combo box to select a record and then have that data fill in text boxes? ie select a name from the combo box on a form and then have name, address, phone, etc text boxes filled in automatically. Thank you :)

[Brettrb]

Yes it will do that, just use the following script as the After Update Event for your combobox:

Sub ComboBoxName_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[RecordName] = '" & Me![ComboBoxName] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Then just make sure you have text fields on the form that link to the Name, Phone number, etc. in your table.

Brett Beckett
brettrb16@yahoo.com