How to create combo box with data from table

[sprahalad]

I have developed a form and on this form I have one combo box cmbDate. Please help me to fire a query to selected specified data from my master table everytime based on Combo Box date selection.

[vb5prgrmr]

Use click event of combo box... or perhaps the change event...

[Kinwang2009]

As said by vb5prgrmr, use SQL statement in change event of ComboBox.

[sprahalad]

Use click event of combo box... or perhaps the change event...

Hi It worked thanks

[sprahalad]

Hi It worked thanks

Hi I have another query could you please help me. In my database I have following total data range Example (Line 107 From 1001 to 3000)
And we enter data like
Line From to
107 1001 1010
107 1010 1020
Keep going up to 3000

Some time we repet station and I want to check that
like above 1001 to 1010 and if 1005(Instead 1010) it shoud be higlighted.

Thanks in advance

regards
Prahalad