Combo Box not allowing selection

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi all!

I have tried asking this questions once before and did not
get a response, went back to the drawing board and here I
am again. So here goes - -

I have a combo box in a subform that is filtered based on
an option group selection in the main form. For some
unkown reason, the combo box will not allow me to make a
selection, which thereby is not allowing me to make
additional entries into my subform.

This is the row source for my combobox:

SELECT tbl_Lit_Broch.Discipline, Tbl_Lit_Boch.Description,
Tbl_Lit_Broch.ID FROM tbl_Lit_Broch WHERE
(((Tbl_lit_Broch.Discipline)=Forms!
Frm_Main.Discipline_Frame));

This is really wierd because I did something similar in
another database just not using a subform combobox
(combobox was on the main form) and I can make selections
just fine.


Help if you can.

Emma
 
Hi Emma.

It appears your combo is behaving as read-only. There are several possible
causes for this, e.g.:

- Is the combo's Locked property set?
- Is the subform's AllowEdits set?
- Is the subform's Enabled set?
- If the RecordSource for your subform is a query, can you edit records if
you open the query directly?
 
Back
Top