Open a blank record during editing

A

Anna

Hi: This is a query which is running on my edit form. Here i need it
will open those tickets which status is not null. If user enters any
TicketNumber which status is null it gives message TicketNumber is not
exist. As right now if i try to open the TicketNumber which status is
null it open a form with blank record in the table.

SELECT tbl_Request.TicketNumber, tbl_Request.TransmittalNumber,
tbl_Request.RequestDate, tbl_Request.SendersID, tbl_Request.CustName,
tbl_Request.AccountNum, tbl_Request.Address, tbl_Request.City,
tbl_Request.State, tbl_Request.Zip, tbl_Request.TechID,
tbl_Request.CreditAmountRequest, tbl_Request.WorkOrderDate,
tbl_Request.Comments, tbl_Request.Status, tbl_Request.CreditAmount,
tbl_Request.Subject, tbl_Request.SScrcID,
tbl_Request.WONotPulledReason, tbl_Request.CreditReason,
tbl_Request.CreditOtherReason, tbl_Request.DenialOtherReason,
tbl_Request.CreditIssuedQ, tbl_Request.WOPulledQ,
tbl_Request.CompleteDate, tbl_Request.DenialReason,
tbl_Request.WorkedDate, tbl_Request.SubControlNumber
FROM tbl_Request
WHERE (((tbl_Request.TicketNumber)=[Enter Ticket Number:]) AND
((tbl_Request.Status) Is Not Null));

Thanks.
 
Top