In fact, I'm getting a Run Time Error: 2465 "MS Access cannot find the field "Status" referred to in your expression"
L. --- In [email protected], "winpins" <[EMAIL PROTECTED]> wrote: > > Makes sense....I tried it just now though and it still doesn't work :( > Any other suggestions? > > L. > > --- In [email protected], Lonnie Johnson <prodevmg@> wrote: > > > > Move your code to the report headers format event procedure. When > the Report Open event is fired there are no values in the textboxes > yet. > > > > > > > > > > > > > > > > > > > > May God bless you beyond your imagination! > > Lonnie Johnson > > ProDev, Professional Development of MS Access Databases > > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ---- > > From: winpins <winpins@> > > To: [email protected] > > Sent: Wednesday, January 31, 2007 9:29:39 PM > > Subject: [ms_access] Invisible Columns in Report > > > > Hello all: > > > > This is the code I've placed in "On Open" on a Report I have. The > > boxes (columns) are not visible when the Report opens, however, > when > > Select is chosen in the Filter Box, they do not reappear. Any > > suggestions to make this work? > > > > Private Sub Report_Open( Cancel As Integer) > > 'Make 2 Columns in report invisible unless Auction is chosen to > > filter by. > > Me!Label80.Visible = False > > Me!Box86.Visible = False > > Me!Label79.Visible = False > > Me!Box85.Visible = False > > Select Case Me.Status > > 'When AUCTION is selected to filter by in STATUS, the 2 columns > > become visible. > > Case "Auction" > > Me!Label80.Visible = True > > Me!Box86.Visible = True > > Me!Label79.Visible = True > > Me!Box85.Visible = True > > Case Else > > 'nothing > > End Select > > End Sub > > > > Thanks much, > > > > L. > > > > > > > > > > > > > > > ______________________________________________________________________ > ______________ > > Need a quick answer? Get one in minutes from people who know. > > Ask your question on www.Answers.yahoo.com > > > > [Non-text portions of this message have been removed] > > >
