Re: Missing something basic - Combobox updating table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <DiverGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F7910C50-95F1-4C4C-B861-95787D95BE88@xxxxxxxxxxxxxxxx
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,



.

Relevant Pages

  • display of a combobox (should be simple..)
    ... The control source is based on ... combobox when making a choice. ... sufficient width, then it looks fine for selecting a value, but when ... text will it alter the fields in the table it's based on?) ...
    (microsoft.public.access.forms)
  • Re: Automating a report that is based on a query
    ... Then modify your query to 'look at' the form's combobox to pick up the ...  for the query to work, the form must be open and a location selected. ... form, selecting a location, and clicking on the new command button you added ... (which opens the report). ...
    (microsoft.public.access.queries)
  • Re: Sorting in a subform
    ... >whose Control Source shows the name from the combobox. ... You can only sort on a field in the form's record source ... Create a query based on your table and add the combo box's ...
    (microsoft.public.access.formscoding)
  • Re: Automating a report that is based on a query
    ... By selecting a location from ... Then modify your query to 'look at' the form's combobox to pick up the ... for the query to work, the form must be open and a location selected. ... base your report on your query. ...
    (microsoft.public.access.queries)
  • Re: list box updating
    ... How about using a combobox, typing the start of the name, then selecting the ... requery the form, base the form on a query, and in the query, use the value ... ?And what do you mean by "the listbox is updated"? ...
    (microsoft.public.access.formscoding)