By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Adding a row to a combo box

P: n/a
I have spent all day trying to use MS sample code AddAllToList()
I have followed the instructions exactly but the combo box is always
blank.
If I change the RowSourceType to table/query I get a list (obviously
without the additional row) but when the RowSourceType is AddAllToList
I get a blank list.

1. Set the RowSourceType to AddAllToList
2. Enter in the tag setting the column number, in my case 1 but I have
tried others.

Result blank list.
Can anyone help to throw some light on this please.
I am using Access2K

Alex
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I should have said that if I put msgboxes or debug.print into the code I do
not get any messages. It does not appear to be even accessing the code when
I select the combo box.
Alec

"Alex" <al********@hotmail.com> wrote in message
news:49**************************@posting.google.c om...
I have spent all day trying to use MS sample code AddAllToList()
I have followed the instructions exactly but the combo box is always
blank.
If I change the RowSourceType to table/query I get a list (obviously
without the additional row) but when the RowSourceType is AddAllToList
I get a blank list.

1. Set the RowSourceType to AddAllToList
2. Enter in the tag setting the column number, in my case 1 but I have
tried others.

Result blank list.
Can anyone help to throw some light on this please.
I am using Access2K

Alex

Nov 13 '05 #2

P: n/a
The RowSource can be a list of values, usually like this:

"Item A";"Item B";"Item C"

If you first extract the RowSource to a variable then re-assign the
RowSource to:

yourVariable & ";"""ItemToAdd""""

and this will add the item to the end of the list.

HTH

Alec Christie
alec_e_christie(at)hotmail(dot)com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

P: n/a
al********@hotmail.com (Alex) wrote in message news:<49**************************@posting.google. com>...
I have spent all day trying to use MS sample code AddAllToList()
I have followed the instructions exactly but the combo box is always
blank.
If I change the RowSourceType to table/query I get a list (obviously
without the additional row) but when the RowSourceType is AddAllToList
I get a blank list.

1. Set the RowSourceType to AddAllToList
2. Enter in the tag setting the column number, in my case 1 but I have
tried others.

Result blank list.
Can anyone help to throw some light on this please.
I am using Access2K

Alex


Alex, are you trying to add a single row to your combobox? If so, you
need the On Not In List event procedure.
David
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.