Help Help Help

[singingshiver]

I have a database with an open issues form that currently shows all the issues in the database. There is a check box that indicates when an issue has been closed by being ticked. I now need the a closed issues form and an open issues form that will contain the respective issues which is determined by whether the check box is ticked.
Any ideas???
Thanks very much for your help.

 

[Fuga]

Base your forms on queries from the issue table.

in the criteria for the "closed field", put -1 in one query and 0 in the other. (provided it is a yes/no field)

Fuga.

 

[singingshiver]

Thanks for the reply.
Do I need to create 2 queries then for the open issues and the closed issues? And then get the queries set up to recognise the check box and then once that works link the queries to new forms?

 

[Fuga]

That´s the way I would do it, yes.


Fuga.

 

[cogent1]

You could also use one parameter query which would prompt you to enter Yes or No and open the form with the appropriate records depending on your response.

 

[singingshiver]

how do i go about doing this?

 

[Fuga]

Put something like

[open issues]

in the criteria for the field.

Fuga.

 

[cogent1]

Put a message in square brackets in the criteria line of your query, something like:

[Enter Yes for closed issues or No for open issues:]

In design view, go to Menu item Query /Parameters and enter the same text in the parameter window and select Yes/No as Data Type. The query won't work as planned if you omit this step.

This message will pop up when you invoke the form on which the query is based and you have to respond appropriately.