Missing something basic - Combobox updating table

Working with Access 2003. I have a table of users, their phone numbers, and
job classes called tblUsers. A query extracts that information into
qryUsers. I have a form that uses the query as the record source called
frmUsers. The form only contains a single combobox so someone can select the
user for which they wish to view data in other forms. It works fine for the
first user on the list in the combobox. Selecting any other user in the
combobox causes the first record in the table to change to that user's name.
For example:

The table and the query both contain:
Timmy
Bobby
Billy
Bubba

The form's combobox box initially displays the names in the order shown
above. Selecting any name other than Timmy, changes Timmy's entry in the
table to Bobby or Billy or Bubba or whatever was selected. Timmy's name then
no longer appears on the combobox list.

I have tried to lock the table's name column down to "no duplicates". That
worked while the form is displayed and it prevented the name changes but when
the form is closed an error message appears that a duplicate entry was
detected and it was unable to update the table.

Also, tried changing the Allow Edits field in Properties to No but that
disabled the ability to select another name.

Apparently, I'm missing something very basic. I only want the combobox to
display the names. No editing should take place. Any thoughts, suggestions,
or guidance will be very much appreciated.

Thanks,

Sounds as though your combo box is bound to the form's underlying
recordsource. Based on what you're describing, the form itself probably
doesn't need to be bound, much less the combo box.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"DiverGuy" wrote in message
...
Working with Access 2003. I have a table of users, their phone numbers,
and
job classes called tblUsers. A query extracts that information into
qryUsers. I have a form that uses the query as the record source called
frmUsers. The form only contains a single combobox so someone can select
the
user for which they wish to view data in other forms. It works fine for
the
first user on the list in the combobox. Selecting any other user in the
combobox causes the first record in the table to change to that user's
name.
For example:

The table and the query both contain:
Timmy
Bobby
Billy
Bubba

The form's combobox box initially displays the names in the order shown
above. Selecting any name other than Timmy, changes Timmy's entry in the
table to Bobby or Billy or Bubba or whatever was selected. Timmy's name
then
no longer appears on the combobox list.

I have tried to lock the table's name column down to "no duplicates".
That
worked while the form is displayed and it prevented the name changes but
when
the form is closed an error message appears that a duplicate entry was
detected and it was unable to update the table.

Also, tried changing the Allow Edits field in Properties to No but that
disabled the ability to select another name.

Apparently, I'm missing something very basic. I only want the combobox to
display the names. No editing should take place. Any thoughts,
suggestions,
or guidance will be very much appreciated.

Thanks,

Yep, that was it! I removed the Control Source from the combobox's
properties and it started working as desired. Knew it was something simple I
had overlooked. Thanks for the help.






"Douglas J. Steele" wrote:

Sounds as though your combo box is bound to the form's underlying
recordsource. Based on what you're describing, the form itself probably
doesn't need to be bound, much less the combo box.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"DiverGuy" wrote in message
...
Working with Access 2003. I have a table of users, their phone numbers,
and
job classes called tblUsers. A query extracts that information into
qryUsers. I have a form that uses the query as the record source called
frmUsers. The form only contains a single combobox so someone can select
the
user for which they wish to view data in other forms. It works fine for
the
first user on the list in the combobox. Selecting any other user in the
combobox causes the first record in the table to change to that user's
name.
For example:

The table and the query both contain:
Timmy
Bobby
Billy
Bubba

The form's combobox box initially displays the names in the order shown
above. Selecting any name other than Timmy, changes Timmy's entry in the
table to Bobby or Billy or Bubba or whatever was selected. Timmy's name
then
no longer appears on the combobox list.

I have tried to lock the table's name column down to "no duplicates".
That
worked while the form is displayed and it prevented the name changes but
when
the form is closed an error message appears that a duplicate entry was
detected and it was unable to update the table.

Also, tried changing the Allow Edits field in Properties to No but that
disabled the ability to select another name.

Apparently, I'm missing something very basic. I only want the combobox to
display the names. No editing should take place. Any thoughts,
suggestions,
or guidance will be very much appreciated.

Thanks,