Creating a list of open trouble tickets

[SeanATech]

I have a cmd button on my home screen that I lbled Not Started Trouble Tickets and I am wondering how I can have it open another form or report with a condition that the status of the trouble ticket = "Not Started".
on_click
openform frm_TroubleTickets
where condition = [TroubleTickets]![Status]="Not Started"
All that happens when I tell it to do this is it brings up a new blank page. I have a few trouble tickets created to test these buttons but all that is happening is the blank form. Is there a better way to do this by maybe using a report or query that i can still create an incident off of or is by using a form the only way that I am going to be able to continue to create further incidents? Sorry if this sounds confusing I am trying my best to explain everything as best I can.

 

[vapid2323]

I have a cmd button on my home screen that I lbled Not Started Trouble Tickets and I am wondering how I can have it open another form or report with a condition that the status of the trouble ticket = "Not Started".
on_click
openform frm_TroubleTickets
where condition = [TroubleTickets]![Status]="Not Started"
All that happens when I tell it to do this is it brings up a new blank page. I have a few trouble tickets created to test these buttons but all that is happening is the blank form. Is there a better way to do this by maybe using a report or query that i can still create an incident off of or is by using a form the only way that I am going to be able to continue to create further incidents? Sorry if this sounds confusing I am trying my best to explain everything as best I can.

DoCmd.OpenForm "frm_TroubleTickets", , , "[Status]=" & Chr(34) & "Not Started" & Chr(34)

Will that work?

BTW this outputs

[Status]="Not Started"

the Chr(34) is another way to add in quotes, I have found it to be easy to work with when trying to get the code right.

 

[SeanATech]

I will give that a try and let you know thanks for the quick response Im almost complete for what I can meet on my deadline.