need help with form property

  • Thread starter Thread starter Peter Kaufman
  • Start date Start date
P

Peter Kaufman

Well, no response to my problem of a report not finding a form
property in Access 2003 although the same app works fine in 2000,
20002, so let me ask something else.

Does this work for you in Access 2003?

Create a form property like so:
Option Compare Database
Option Explicit

Private mlngWasAutoID As Long
Public Property Let prpWasAutoID(x As Long)
x = mlngWasAutoID
End Property
Public Property Get prpWasAutoID() As Long
prpWasAutoID = mlngWasAutoID
End Property

And then use the property in a report criteria like so:

@pintWasAutoID=forms!frmWas.prpWasAutoID

I'd appreciate if someone would even try a test for me, 'cause it is
not working here - the report simply prompts for the property.

Thanks a lot,

Peter
 
Set macro security level to low (although there aren't any macros) and
converted to Access 2003 format, and it is working. Might be something
to do with the Jet SP8 although this is an adp.

Thanks,

Peter
 
Back
Top