Combo box won't let me select from the list

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.
 
P

Pete D.

Check the control/row source for both very careful checking for spelling
errors and table/query names
 
R

Rick Brandt

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

Top