Hello,
I'm trying to pass a VBA snippet that stored in a table into two text box from a single combo box. The VBA code I'm using is as followed in the after update of the combo box. The problem I'm having is instead of setting the value, it is passing the value as a string. for example "Date()" for today instead of 5/14/2018. Any Ideas?
The table stores the following
ID, Description, Start Code, End Code
I'm trying to pass a VBA snippet that stored in a table into two text box from a single combo box. The VBA code I'm using is as followed in the after update of the combo box. The problem I'm having is instead of setting the value, it is passing the value as a string. for example "Date()" for today instead of 5/14/2018. Any Ideas?
Code:
me.txt_start = cmb_daterange.column(2)
me.txt_end = cmb_daterange.comun(3)
The table stores the following
ID, Description, Start Code, End Code