Form with lookup

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have tried all kind of things, but I don't seem to be able look up data
from a drop drown list.

I made a form from the employee table. I would like to select an employee
name from a drop down list, or perhaps even be able to type the first
letter, and go the that letter and select an employee whose data I want to
look at. When I use the list box or combo box, I can scroll down and pick an
employee, but when I click on that employee, I get a run time error 3022 and
a message tells me that would create a duplicate record in the table.

What am I doing wrong?
 
I suspect you are getting the error because your combo box is based on a
bound field and Access thinks you want to add another identical primary
key.Your combo box should be unbound, with AfterUpdate code to match the
selected employee id to the employee id field located in the form. If this
sounds right to you, email your database to me and I will create the code
for you.

Con Giacomini
 
That is exactly what is happening. I just emailed you the database which is
still a little more than 2 megs after deleting lots of stuff not related to
the current issue.
Thank you in advance for your help. For almost a week I am trying this or
that and I can't get it to work
Annelie
 
Hi, did you get my email???
Annelie

Annelie said:
That is exactly what is happening. I just emailed you the database which is
still a little more than 2 megs after deleting lots of stuff not related to
the current issue.
Thank you in advance for your help. For almost a week I am trying this or
that and I can't get it to work
Annelie

want
Click to expand...
 
Back
Top