Assigning Variable from Combo Box

[Edgar Thoemmes]

I have a combo box bound to a table, the row source is based on a query of
the table returning 3 fields (ID, TimePeriod and NumberDays)

How can I assign the value of NumberDays to a variable?

I am trying to create a dynamic SQL statement like:

strExpired = "tblContracts.EndDate<Date()+" & VARIABLE & " And
tblContracts.EndDate>Date()"

Thanks

 

[Nikos Yannacopoulos]

Edgar,

The syntax to refer to the third column of the current selection of a combo
on a form is:

Forms!FormName!ComboName.Column(2)

(the index of the first column is 0).

HTH,
Nikos