I have yet another problem. I am finding many suggestions throughout the web, but have yet to find one that works. I have a form that has 4 tabs each containing a subform. There is a checkbox on the Main form that basically makes three of the four Tabs obsolete (There will never be any information in those subforms). I am trying to grey out the fields in the subform or the whole subform when the checkbox on the Mainform is checked. Also, I want to keep information from being added to those subforms. Meaning, if I cannot disable the fields, I want a warning of some sort if someone tries to enter a record.
Does anyone know of a book that specializes in Visual Basic for Application in Access? I have a VB book that is great, but is not always useful for when I'm working strictly from Access. In case you are wondering, I have VB at home that I use, but at work we only have Access available to us.
Private Sub Form_Current()
Me.Subform.Visible = not Me.Checkbox
If your company is serious about Access development then I'd suggest Access Developer xxxx, where xxx is the version you are using.
published by Sybex.
authors (of the 2002 version) Litwin, Getz & Gunderloy
Get both the 'desktop' & 'enterprise' versions