Combo box won't let me select from the list

  • Thread starter Thread starter Jacq
  • Start date Start date
J

Jacq

Originally I had a sub-form with a Table as the RecordSource but I couldn't
get the records to sort chronologically using the date field without having
to apply the filter everytime I opened the form. Having read through the
posts I changed the RecordSource and linked it to the query but now the combo
boxes (there are two - one for ContactTitle and one for State) won't let me
select from the list of options.
 
Check the control/row source for both very careful checking for spelling
errors and table/query names
 
Originally I had a sub-form with a Table as the RecordSource but I
couldn't get the records to sort chronologically using the date field
without having to apply the filter everytime I opened the form. Having
read through the posts I changed the RecordSource and linked it to the
query but now the combo boxes (there are two - one for ContactTitle and
one for State) won't let me select from the list of options.

Post the SQL of your Query. Sounds like you ended up with a query that
produces read only output.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box filter 1
Stop entry data to my combo box! 13
Combo Box 3
Combo Box in Continuous Form 1
Combo Box Question 4
Synchronize Two Combo Boxes on a Form 5
Combo box to control two sub forms 2
Combo Box Help 7

Back
Top