Auto Fill Name & Address

[MickJ]

I am trying to Auto Fill Address, City, State And Zip fields on a VB form that reads an Access DB. Choosing a name from a combo or list box would automatically fill in the other fields. (that's my theory anyway). Any suggestions would be helpfull, writing the code for me would be better Thanks.

 

[CasperTFG]

On the Click event for the combo box, move to the record that matches and fill in the remainder of the forms.

If your using ADO, you first fill the Combo box on form load with the items from the DB.
[tt]
With rs
Do until .EOF
Combo1.AddItem !field_for_combo
Loop
End With
[tt]
Then when the combo is clicked.
[tt]
Private Sub Combo1_Click()
With rs
.Filter = "field_for_combo=" & Combo1.Text
txtLastName = !LastName
txtFirstName = !FirstName
txtAddress = !Address
.Filter = ""
End With
End Sub
[tt]
Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow