Auto filling the wrong name

G

Guest

Hi,

I have a form that has an entry that requires the user to enter "submitted
by" info for the form. The names are selected from an employee roster that
is saved in a separate table. I have two users who have similar names
example: John smith and Joe smith. Names are saved last name first.

When they are filling in the form, access will not let joe smith enter his
name. It will always default to John smith. How do I fix this so that Joe
can enter his name?

thanks
 
A

Amy Blankenship

MB said:
Hi,

I have a form that has an entry that requires the user to enter "submitted
by" info for the form. The names are selected from an employee roster
that
is saved in a separate table. I have two users who have similar names
example: John smith and Joe smith. Names are saved last name first.

When they are filling in the form, access will not let joe smith enter his
name. It will always default to John smith. How do I fix this so that
Joe
can enter his name?

What type of control are you using, and how are you using it?
 
G

Guest

Amy,

Not sure exactly what info your looking for but here is some more info.

the original table has first and last names but i created a query to combine
to full names. the form uses the full names from the query to fill in the
form.

hope that helps.

thx for the reply
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top