469,602 Members | 1,618 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Filter report using form filter

121 100+
Hi,

I am filtering a report using the form filter with the following code

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "report1", acViewReport, , Me.filter
  2.  
Which works fine untill I filter the form on one of the fields which is a lookup field
and I get the enter parameter value box which is looking for the Assetdetails.details field which contains the following text for some reason it has put Lookup_ at the front of the field

Lookup_AssetDetails.Details
I think that the because the lookup field actually stores the ID number rather than the text in the form

When I open the form in design view in the filter property it contains the following string

([Lookup_AssetDetails].[Details]="AKG C414 Microphone Condenser")
Is there anyway around this problem?

regards Phill
Nov 25 '09 #1
2 3243
ChipR
1,287 Expert 1GB
You could probably use:
Expand|Select|Wrap|Line Numbers
  1. Replace(Me.filter, "Lookup_", "")
Nov 25 '09 #2
NeoPa
32,198 Expert Mod 16PB
Perhaps if you explained exactly what you're trying to do (Give some more detail as we cannot check out what you're talking about by looking at the database - We don't have it).

Is Details a lookup field? If so, what are the details? What's the name of the field you're really trying to filter on?

We need some details even to understand the question properly, but certainly to provide a decent answer.
Nov 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by CSDunn | last post: by
8 posts views Thread by dick | last post: by
16 posts views Thread by Nhmiller | last post: by
1 post views Thread by lorirobn | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.