insert value in a textbox based on a combobox

[brs]

hi guys,

i have a bill search form which should show bill falling between a date range.


date range i have added in a table - range - which has three fields = range, begindate, enddate.
now in bill search formi have the combo box - rangecombo and two text boxes begintext and endtext.

when i change range in rangecombo the values in begintext and endtext should change accordingly.how can this be done? help

[Bob Fitz]

If rangecombo uses table range as its data source, you could include begindate and enddate as hidden columns and set the control source property of begintext and endtext to something like:
=rangecombo.Column(1)
and:
=rangecombo.Column(2)
Remember that the column count is zero based, so (1) is the second column and (2) is the third column.

[brs]

thanks bob
works perfectly

[Bob Fitz]

Good. Glad to be help