Reporting text from a form to a query Access 97

[murphysdad]

From a combo box (ReportType)on the form(frmCreateReport), I want people to choose what type of report they would like(incomplete or complete).
When they select incomplete, I am trying to get a value of "is Null" to report in the field(CompletionDate) of the query(qryReportBuilder) or "is not null" for when they choose "complete".

There is a submit button I would like to use when they choose there selection.

Thanks!

 

[KenReay]

Hi

Make the combo box into a 2 column combo box.

The second column to be hidden by setting its width to zero

Set the value of the second column to False (for incomplete) and True (for Complete) - how you do this depends on how you are populating the combo.

Amend your query to have a calculated column so Complete:=Not IsNull(CompletionDate), and set the critieria of this column to cboName.Column(2)

using your own name for combo box of course Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use