Query help checking required

[robcarr]

Hi,

I am using the code below to find a record

SELECT tblItemReceived.ReferenceNo, tblItemReceived.DateLogged, tblItemReceived.TimeLogged, tblItemReceived.LoggedBy, tblItemReceived.ItemType, tblItemReceived.CustomerRef, tblItemReceived.DateClosed, tblItemReceived.ClosedAs, tblItemReceived.TimeClosed
FROM tblItemReceived
WHERE (((tblItemReceived.ReferenceNo)=[Enter Reference Number to Find]));

is there a way to add a check and if the tblItemReceived.ClosedAs is blank then open form, else dont open it, also if the tblItemReceived.ReferenceNo doesnt exist dont open. if exists open form.

Hope this is of use, Rob.

 

[HarleyQuinn]

If you are using a recordset do it something like this:

If Not IsNull(rs!ClosedAs) then
[green]'open form[/green]
else
[green]'do some other checking[/green]
end if

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[lupins46]

You cannot issue commands within a query.
I think you need to consider basing the form you refer to on a query which selects just the records for which ClosedAS is null.