combo box won't allow me to select anything

[Mark Kubicki]

I may be going about this the wrong way...

I have a single view form, that as part of its detail section lists a
manufacturer (txtManufacturer), and has a command button (cmdRepInfo) that
opens a pop-up form (not a subform) with information about the
manufacturer's representative (frmRepInfo)

The current rep for any of the manufacturers frequently changes, so I want
to give the end user a quick way of updating this information...

To the frmRepInfo, I've added a command button (cmdUpdateRepAgency) which
makes visible an unbound combo box (cboRepAgencyList) and a command button
(cmdAcceptUpdate).
- My thought is that the user would select an agency from the combo (new
agencies seldom happen; instead they trade and change their line card of
manufacturers like baseball players)
- When the user clicks cmdAcceptUpdate, I'd grab the selection from the
combo box, and an update query on the table tblManufacturer-RepAgency would
run, the cboRepAgencyList and cmdAcceptUpdate would become hidden, and the
form wouldbe requeried...

However... while the combo box display the correct list, I can't select
anything...
I'm at a loss, and any suggestions would be greatly appreciated.

thanks in advance,
Mark

 

[Linq Adams via AccessMonster.com]

Not being able to make a selection from a combobox usually means that the
form involved cannot be updated. Does the form have AllowEdits set to No? Is
the form based on a query that cannot be edited?