Combo box

[leecsone]

HI

I have a form that search for names (last Name, First Name, ID Numder.and I have two check boxes. Now below all this I have a combo box. I can type in a name in the combo Box click on the down arrow that shows all the names with the name I typed highlighted. Now after I click on the name the only part of the name that shows is the Last Name in the text box above. How can I get all the info to show in the text boxes after I click in the combo box.

The reason for the search for names is so I can modify the name in case there was a name change or misspelled name.



leecsone
leec@northrock.bm

 

[WayneRyan]

leescone,

If I understand what you're saying, the combo box is
updating one field (the last name). In the form's design
view, right-click on the combo and select properties. Then
look at the events tab. There is probably an event function
in the Before or After Update event.

That code probably has:

Me.LastName = Me.Combo.Column(0)

You need to add:

Me.FirstName = Me.Combo.Column(1)
Me.IDNumber = Me.Combo.Column(2)

I don't know their exact names, but this should get you
started.

Wayne

 

[leecsone]

check box

HI WayneRyan


I have tried the code but I get an error (Microsoft Access can't find the Macro "ME"). I tried to set the macro to "M" but I don't see "ME" listed in macro. Please advise

Thank You for you quick responds.

leecsone
leece@northrock.bm