Adding a row to a combo box

[Alex]

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

[Paradigm]

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

[Alec]

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!

[David Neagle]

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