How do I change the value in a combo box in Access using VBA?

G

Guest

I have Text box and a combo box that is being used to generate a query to
fill out the form. The Textbox is the current date but may be changed. The
combo box has a list of dates of evaluations (not all dates have evaluations)
which is populated with a query of the evaluations table of all dates not
exceeding the date in the text box. The value of the combo box is blank and
must be selected prior to the query for the form being completed. The most
recent date should be the default. I have trying to use the example in help
of setting ListIndex for the combo control but I keep getting an error
message ("Incorrect use of ListIndex"). I have tried various syntax but to
no avail.
 

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

How do I add a COLUMN to combo box 4
Combo Box selection returns a Date() in another field 7
Combo Box Help?? 3
Code to populate combo box 1
Run query to feed combo box 2
Choose a value from a combo box based on a text box 0
Combo box based on anothr combo box 2
Showing combo box results from the results of another combo box 4

Top