Adding items in access combo box progrmmatically

J

Jack

Hi,
I am trying to add items to a Access combo box programatically as follows:

' Load the drop down
With cbTechnique
.AddItem "Orders by Customer (refresh method)"
.AddItem "Orders by Customer (CreateParameter method)"
.AddItem "Add an order detail item"
.AddItem "Get Revenue by week"
.AddItem "Add an order"
End With

But this seems to be not working. Any help is appreciated. Thanks in advance.
 
D

Dale Fye

Jack,

Generally, I shy away from building combo and list box lists
programmatically. It is much simpler to maintain if you build these lists in
tables and reference the table or a query based on a table as the rowsource
for the combo.

HTH
Dale
 
K

Klatuu

"seems to be not working"
is a bit vague.
What is not working?
Are you getting an error, if so, what error and on what line of code?
Where is this code?
How do you know it is actually executing?
What version of Access are you running?

Without the detail above, all I can answer is
"You're not doing it correctly"
 
J

Jack

Thanks to everyone who has given great advise. Actually I am using Access
2000 version. With this I believe I cannot do coding that I have done. I took
your advise and it works now. Regards.
 

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

Having trouble with combo boxes. 11
add items to a combo box with code 1
RowSource Property Lost 9
Set value of combo box to first item in list 10
Adding items to a list box in Access 2000 4
ACC 2002: Sort a ListBox with no SQL rowsource 4
How do you populate Combo Box from ADO recordset? 2
AddItem skips every other item 2

Top