Auto filling the wrong name

[MB]

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

 

[Amy Blankenship]

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?

 

[MB]

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