[AccessD] Filter by Form stuff

Arthur,

I use code for this sort of thing, I have no idea if this is the correct/best way, but it does work really well.

'----------- code sample start ----------------------------------------
Private Sub cbAdminChoiceAPLID_AfterUpdate()

Dim sSQL As String
Dim lAPLID As Long

lAPLID = Me.cbAdminChoiceAPLID.Value
sSQL = "SELECT * FROM tbl_ProgramListingFixed WHERE (((APLID)=" & lAPLID & "));"

Me.RecordSource = sSQL

End Sub
'------------ code sample end -----------------------------------------

Hope that helps.

cheers
Darryl


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: Tuesday, 15 April 2008 5:16 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Filter by Form stuff


Does anyone understand this stuff? I certainly don't. When I inquire upon
the current filter I get this (to me) strange Lookup_* stuff that I do not
comprehend. I need to strip all this and I know how to do Replace() etc. but
that doesn't seem to be the issue.

I have a form. The user elects to impose a filter. I want to be able to
print the report, respecting said filter. This has proved problematic. I
need to figure this out. Any suggestions?

As always, TIA,
Arthur

(In the immortal words of the Simpsons: there are no stupid questions, only
stupid people. I confess to membership in the latter category. I am a stupid
person. Ok, fine. Let us move on and grant me the wisdom of the smart people
here.)
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.