Filter Form with "CurrentRecord" property

[bbrazeau]

I have a form that pulls a lot of info from different tables together in a single record. There is no unique ID field I could set to match like in a typical filter. ie "CustomerID = " & CustomerID
What I would like is to filter out all but the current record, then I'm going to use a DoCmd.RunSavedImportExport "MyExport" to save the record to a pdf for distribution.
Does anyone know how to do this?? The following doesn't work.

Dim sFilter As String
Dim lngCurrRec as long
lngCurrRec= Me.CurrentRecord
sFilter = "[Me.CurrentRecord]= '" & lngCurrRec & "'"
'assign the filter value,and turn filtering on
Me.Filter = sFilter
Me.FilterOn = True
DoCmd.RunSavedImportExport "MyExport"
Me.FilterOn = False

[June7]

There must be some unique criteria that can be applied, even if it is every field in the dataset, to isolate the record.

[bbrazeau]

Hi June7, At present there is a way to uniquly identify the record with a 3 field criteria, but I was just looking for a simple means to do this that would work and continue to work as the database matures and potentialy develops the need for more complex criteria.
As far as my question goes...Is there a way to filter the form to weed out all but the current record based solely on the record the user has currently navigated to. In other words leave it to the user to find the record they want then spit this record out as a pdf file?
The reason I'm focusing on the "CurrentRecord" property is this seems as though it would be a perfect fit for what I'm trying to do.

[June7]

Not that I know of. Never used CurrentRecord property. Since your attempt to use it as filter criteria fails, I presume that is not valid use and filter criteria must be data.

Do you want to output form or report to pdf?