unable to select from combobox.

  • Thread starter Thread starter Robert Johnson
  • Start date Start date
R

Robert Johnson

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert
 
Is your form's Record Source a query? If so, if you open the query can you
edit the field that the combo box is bound to?

Is the combo box a multi-column box? If so, is the data type of the bound
column correct for the field you are trying to insert the data into?
 
Wayne Morgan said:
Is your form's Record Source a query? If so, if you open the query can you
edit the field that the combo box is bound to?

Is the combo box a multi-column box? If so, is the data type of the bound
column correct for the field you are trying to insert the data into?
Click to expand...
Yes, if I open the query I can manualy type in new data. No, it is a single
field table and single column box.

Robert
 
You need to check the following:

* The AllowEdits Property of the ComboBox (Yes/True).
* The AllowAdditions / AllowEdits Prperty of the Form.
* The Recordset Type Property of the Form (should _not_ be "Snapshot").
 
Robert -

Aren't you and I already discussing this in a thread in another newsgroup?
Please don't post the same question multiple times. It causes many people to
duplicate their efforts and try answering the same question, and the
separate threads mean that everyone cannot see what others are posting.
http://www.mvps.org/access/netiquette.htm
 
Opps, sorry Ken.

Robert
Ken Snell said:
Robert -

Aren't you and I already discussing this in a thread in another newsgroup?
Please don't post the same question multiple times. It causes many people to
duplicate their efforts and try answering the same question, and the
separate threads mean that everyone cannot see what others are posting.
http://www.mvps.org/access/netiquette.htm
Click to expand...
 
Back
Top