Re: Missing something basic - Combobox updating table

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

  • Re: Combo box / Subform Question
    ... After the combobox selection is made, ... the query sees the selected record and that one gets displayed on ... "Jeff Boyce" wrote: ... value to find the correct record to display. ...
    (microsoft.public.access.formscoding)
  • Re: Combo boxes in forms
    ... This is the ONE field from the query ... simply address the combobox field ... each field in that combo box will use in the display when you press ... a single field and have that be the visible and maybe bound field. ...
    (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: 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: AllowAdditions=False makes unbound controls blank out when recordcount=0.
    ... If the RecordSource is not a read-only query, one workaround is to allow the ... You can place other controls in the Form Header section and they are ... there are still display problems with those ... > the after update event of the combobox. ...
    (microsoft.public.access.forms)