Art-
It's not possible to do what you want in a Continuous Form. The reason is there's really only ONE copy of each control in any form, and in a Continuous Form, it's the controls on the record that has the focus. So, when you set Visible for the Current row, you're setting it for all of them. The others are just "painted" by Access. There are a few things you can do with Conditional Formatting, but unfortunately setting Visible is not one of them. (You can set Enabled.)
Better give up this idea and go with Plan "B". 😃
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 19, 2015, at 9:21 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a continuous form called frm_categories_list. On it I have a image of a flag icon called imgIsActive and a checkbox which is bound to a field called chkIsActive. I have put the following code in both the form_open and form_current procedures:
If Me.chkIsActive = True Then
Me.imgActive.Visible = True
Else
Me.imgActive.Visible = False
End If
The issue it is only taking in the account the setting in the first record. If on uncheck the chkIsActive then it hides the imgIsActive in all the records and not just the one;s where they are actually unchecked? If it is checked in the first record then imIsActive is visible in all records. I am just a little confused.
Thanks,
Art Lorenzini
Sioux Falls, SD
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar