Help with VB code with form

[khawar]

Try this Sql

SELECT Table1.number, 
Table1.month, 
IIf(IsNull([month]),"Job Completed",[Status]) AS [Current Status]
FROM Table1

 

[abz_y2k]

i need to save it to so i can create reports to show list fo jobs completed on monthly basis.

one more thing, instead of having combo box, can you just use normal txt box and let it display various messages like job completed, cancelled when you enter the date

 

[khawar]

Paste the Sql in the query and after that you can show the job in the report even the data is not saved in table

Answer to your second question is no text box cannot show list of values

but there is a work around

Add a combo box below the text box set the height of combo to zero
Add values to combo
Now on the change event of the text box drop down the combo and after update event of the combo update the text box it will show the effect of list of values below a text box