By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Sub Form

P: n/a
This code works fine on the main form, which is called “Films”

Private Sub Form_Current()
Select Case [Combo13]
Case "Film"
[ASA].Visible = True
Case Else
[ASA].Visible = False
End Select
End Sub

I have a sub-form called “Pictures”. On this sub-form I have field called
“Pixels”. How can I refer to this field to make it invisible when [Combo13]
on the main form shows “Film” ?

Thanks

Peter

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 28 Oct 2003 20:03:52 -0000, "Peter Barker"
<pe***@exeter.flyer.co.uk> wrote:

On the line after End Select write:
Pictures.Form!Pixels.Visible = (Combo13 <> "Film")

Similarly you can replace the whole Select Case statement with:
ASA.Visible = (Combo13 = "Film")

-Tom.
This code works fine on the main form, which is called “Films”

Private Sub Form_Current()
Select Case [Combo13]
Case "Film"
[ASA].Visible = True
Case Else
[ASA].Visible = False
End Select
End Sub

I have a sub-form called “Pictures”. On this sub-form I have field called
“Pixels”. How can I refer to this field to make it invisible when [Combo13]
on the main form shows “Film” ?

Thanks

Peter


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.