Make subform visible when a field has a particular value

To expand a little on what Gina wrote, you need both expressions at once:

If Me.[YourField] = "Y" Then
Me.[NameOfSubformControl].Visible = True
Else
Me.[NameOfSubformControl].Visible = False
End If

To simplify the expression, maybe something like:
Me.[NameOfSubformControl].Visible = (Me.[YourField] = "Y")

Since (Me.[YourField] = "Y") evaluates either to True or False, it takes the
place of the word True or False in the expression. One line of code covers
both possibilites. This assumes there are just two possibilites for
YourField.

To place the code in the text box After Update event, in form design view
click the text box to select it, then click View Properties. This will
display the Property Sheet (if it was not already displayed), with tabs for
Format, Data, Event, Other, and All. Click the Event tab, click After Update,
click Code Builder OK. This will open the VBA editor, with Private Sub
and End Sub lines. Place the code between the two. Same for the form's
Current event. To switch to the Property Sheet for the form, click the
little square on the top left where the rulers meet in design view (if the
Property Sheet is displayed). If it is not displayed, double click that
little square, or click it once and click View Properties.

In any case, the Property Sheet title bar will tell you what properties you
are seeing.

JJ1109 wrote:
Thanks Jeanette,

So in the subform I need the same field that's the master field in the main
form, to be the child?

How do I write the expression to make the subform be visible or not? I have
no idea how to write them

thanks again
JJ

Use the link master field and link child field to link the subform to the
main form.
[quoted text clipped - 16 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

To expand a little on what Gina wrote, you need both expressions at once:

If Me.[YourField] = "Y" Then
Me.[NameOfSubformControl].Visible = True
Else
Me.[NameOfSubformControl].Visible = False
End If

To simplify the expression, maybe something like:
Me.[NameOfSubformControl].Visible = (Me.[YourField] = "Y")

Since (Me.[YourField] = "Y") evaluates either to True or False, it takes the
place of the word True or False in the expression. One line of code covers
both possibilites. This assumes there are just two possibilites for
YourField.

To place the code in the text box After Update event, in form design view
click the text box to select it, then click View Properties. This will
display the Property Sheet (if it was not already displayed), with tabs for
Format, Data, Event, Other, and All. Click the Event tab, click After Update,
click Code Builder OK. This will open the VBA editor, with Private Sub
and End Sub lines. Place the code between the two. Same for the form's
Current event. To switch to the Property Sheet for the form, click the
little square on the top left where the rulers meet in design view (if the
Property Sheet is displayed). If it is not displayed, double click that
little square, or click it once and click View Properties.

In any case, the Property Sheet title bar will tell you what properties you
are seeing.

JJ1109 wrote:
Thanks Jeanette,

So in the subform I need the same field that's the master field in the main
form, to be the child?

How do I write the expression to make the subform be visible or not? I have
no idea how to write them

thanks again
JJ

Use the link master field and link child field to link the subform to the
main form.
[quoted text clipped - 16 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

To expand a little on what Gina wrote, you need both expressions at once:

If Me.[YourField] = "Y" Then
Me.[NameOfSubformControl].Visible = True
Else
Me.[NameOfSubformControl].Visible = False
End If

To simplify the expression, maybe something like:
Me.[NameOfSubformControl].Visible = (Me.[YourField] = "Y")

Since (Me.[YourField] = "Y") evaluates either to True or False, it takes the
place of the word True or False in the expression. One line of code covers
both possibilites. This assumes there are just two possibilites for
YourField.

To place the code in the text box After Update event, in form design view
click the text box to select it, then click View Properties. This will
display the Property Sheet (if it was not already displayed), with tabs for
Format, Data, Event, Other, and All. Click the Event tab, click After Update,
click Code Builder OK. This will open the VBA editor, with Private Sub
and End Sub lines. Place the code between the two. Same for the form's
Current event. To switch to the Property Sheet for the form, click the
little square on the top left where the rulers meet in design view (if the
Property Sheet is displayed). If it is not displayed, double click that
little square, or click it once and click View Properties.

In any case, the Property Sheet title bar will tell you what properties you
are seeing.

JJ1109 wrote:
Thanks Jeanette,

So in the subform I need the same field that's the master field in the main
form, to be the child?

How do I write the expression to make the subform be visible or not? I have
no idea how to write them

thanks again
JJ

Use the link master field and link child field to link the subform to the
main form.
[quoted text clipped - 16 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1