Code not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KSIMMSA - 17 Jan 2006 17:42 GMT

I’m trying to update the coding for a report. I am having problems with the
coding on the form. I have it broken down by certain criteria and they are
all working, but one and I can seem to figure this one out. It looking up a
number field and I am using the following syntax:

If Me!SpecificResultCode = "All" Then
If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
stLinkCriteria = stLinkCriteria & "[dbo_rescodes.ResultCode] = " & ""
& (Trim(Me!SpecificResultCode)) & ""
End If

Thanks.

Reply to this Message

Sergey Poberezovskiy - 18 Jan 2006 00:11 GMT

From what I understand, you need to change the first line to

If Me!SpecificResultCode <> "All" Then

HTH

> I’m trying to update the coding for a report. I am having problems with the
> coding on the form. I have it broken down by certain criteria and they are
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

KSIMMSA - 18 Jan 2006 21:50 GMT

Thanks, i got it.

If Me!ChooseResultCode = True Then
If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " &
((Str(Trim(Me![SpecificResultCode]))))
End If

> From what I understand, you need to change the first line to
>
[quoted text clipped - 14 lines]
> >
> > Thanks.

Reply to this Message