query report

[alkrm]

hi, i created a repot for a query which has the field catigory
in the creteria of the catigory field , i wrote this [enter the catigory], so when the user run the query he get he data related to this catigory he wrote,
my question is , can i change the label which he enter the catigory name to a combo box with all the catigories so it safe time and limit the miss spelling

thanx in advance

 

[Mile-O]

Yes, rather than put [Enter the Category], you reference the combobox on your form.


i.e.


[Forms]![MyForm]![MyCombo]