CmdButton to Open Form & Only Show Select Records

[gyli84]

I am creating a helpdesk system and have a form called "Calls" showing all the calls/problems that have been received. I also have a "Manager's Console" form which shows certain information and has a text box called "UnassignedCalls" which shows the result of a query which counts the number of records in the Calls table that has the criteria "Completed" as 0 (False) and "Assigned User" as '' (Null). I want to create a command button that will open the Calls Form and ONLY display Unassigned Calls where "Completed" = 0 and "Assigned User" is Null. Can anyone help?

Thanks

 

[aqif]

Hi

Create a OpenForm macro and specify the parameters in Where condition like

[MyTable]![MyField]=0 and [MyTable]!{MyField2] is null

Hope that'll solve ur problem

Cheers!
Aqif

 

[gyli84]

Thanks for the help, it works beautifully!