changing value of combo.column(1)

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hi all,

Is it possible to change the value of an combobox column? Something like:-

me.cmbDates.column(2) = date()
me.cmbDates.column(3) = "Today"

The combo is build up as a value list at opening of the Form it's on.

Help would be great.

Cheers,
Ludovic
 
I'd need more information for your value list, but if you used a Table/Query
RowSourceType is might look like:

Select ID, Description, Date() As D, "Today" As T From YourTable;
 
Dear Arvin,

Sorry I am lost with your advice. I think it is not the solution i do look
for, below i try to give som more information of the case i look for:-

'I build up the combo box :
Me.cmbDateRange.RowSourceType = "Value List"
Me.cmbDateRange.ColumnCount = 4
Me.cmbDateRange.ColumnWidths = "0cm; ; 0cm ; 0cm"
Me.cmbDateRange.RowSource = ""

'The rowsourse is than filled
Me.cmbDateRange.AddItem "0 ; [All dates] ; 999 ; 999", 0
Me.cmbDateRange.AddItem "1 ; [This Month] ; 1-11-2009 ; 30-11-2009", 1
Me.cmbDateRange.AddItem "2 ; [Last Month] ; 1-10-2009 ; 31-10-2009", 2
Me.cmbDateRange.AddItem "3 ; [Last Year] ; 1-1-2008 ; 31-12-2008", 3

Now later on in the program events, as a reaction on a users choice, i would
like to change the date and it text of ItemData(2) to
Column(1)= [Today]
Column(2)=1-11-2009
Column(3)=1-11-2009

On another instance i would possibly need to change ItemData(1).

Would that be possible, help is greatly appriciated.

Thx,
Ludovic
 
Back
Top