-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Visibility
- Thread starter willlobb
- Start date
Hi Norie, thanks for your reply. Im pretty new to Access - im used to working with Filemaker Pro.
Where would I put the code for that function? and where in the function is the bit that says to hide the field?
Thanks very much,
Will
Where would I put the code for that function? and where in the function is the bit that says to hide the field?
Thanks very much,
Will
Upvote
0
Excel Facts
Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
You would put the function in a module. There is no code for hiding fields.
What the function does is return TRUE or FALSE depending on whether or not the form with the name given is open.
The way to use it would be like this:
Field1.Visibility = IsFormOpen("Main Form")
...
You would put this in the Open event procedure for the subform.
What the function does is return TRUE or FALSE depending on whether or not the form with the name given is open.
The way to use it would be like this:
Field1.Visibility = IsFormOpen("Main Form")
...
You would put this in the Open event procedure for the subform.
Upvote
0
Similar threads
- Solved
