Re: Form hide / unhide

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DebbieG (debbieg_at_accessus-REMOVE-THIS-.net)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 10:50:52 -0500

Xavier,

Here's a thought. In the YesNoField's AfterUpdate event:

    If YesNoField = True Then
        Me.SubFormIdentifierName.Visible = True
    Else
        Me.SubFormIdentifierName.Visible = False
    End If

Debbie

"xavier" <anonymous@discussions.microsoft.com> wrote in message
news:442e01c42b89$cdb0b380$a501280a@phx.gbl...
This is a repost, the suggestion I got before didn't
really help, Ill explain again what I want to acomplish.

I have a main form with a sub form, I would like the
subform either to be grayed out or not visible at all
unless a yes/no box in the main form is checked.

Or alternate solution would be a form button to open the
second form (wouldnt be a subform anymore) but how do I
keep it linked to the main form when data is added to
this second form.

I can do the form button but cant keep records in sync,
I open a particular record > open the form (via a button
on main form) add info on the second form but if I close
and return to this same record and second form the data
is not there but it is in the table that feeds the second
form.

Thanks
Xavier

Relevant Pages

  • Form hide / unhide
    ... Ill explain again what I want to acomplish. ... second form (wouldnt be a subform anymore) but how do I ...
    (microsoft.public.access.forms)
  • Re: Exit Edit Box on Form
    ... so the OnChange fires up at every ... > In Mr. DMNGV's suggestion, the KeyPress does not active after pressing any ... How are you showing the second form? ...
    (alt.comp.lang.borland-delphi)
  • Define a property to pass an array
    ... I need to pass a value from one Form to a second Form called by the first. ... implemented a suggestion to define a property like the following: ... but I need to pass a dynamic array. ... and how do I define a correct property? ...
    (comp.lang.pascal.delphi.misc)
  • Re: whats wrong with "lambda x : print x/60,x%60"
    ... the second form is clearer. ... >> But there is no suggestion that this should be the obligatory form. ... Antoon Pardon ...
    (comp.lang.python)
  • Re: open form from an acdialog form
    ... your suggestion was tried but failed. ... Hmm, it works for me. ... Were you trying to open the second form before the first form had become visible? ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)