O
Olu Solaru
Does anybody know how to reference a query (This query is basically an
expression that concatenates the first name and last name). I used this
query to create a combo list on my form. The problem I having is that I
cannot reference the query in Visual Basic, in an afterUpdate event procedure
(VBA). This event procedure will automatically popoulate the remaining
fields on my form.
It worked when I used another field( EmployeeID), but only when I used the
navigational buttons, everytime I use the combo-box to select an employee, I
get the message that I cannot duplicate value. Which means I will have to
take the primary key of EMployeeID, - which will basically mess up my
database.
So I decided to use the query expression for my combo list.
expression that concatenates the first name and last name). I used this
query to create a combo list on my form. The problem I having is that I
cannot reference the query in Visual Basic, in an afterUpdate event procedure
(VBA). This event procedure will automatically popoulate the remaining
fields on my form.
It worked when I used another field( EmployeeID), but only when I used the
navigational buttons, everytime I use the combo-box to select an employee, I
get the message that I cannot duplicate value. Which means I will have to
take the primary key of EMployeeID, - which will basically mess up my
database.
So I decided to use the query expression for my combo list.