Enabling and disabling controls on a Continuous Subform in Access 2007/2010
I need to enable or disable a control on a continuous subform, dependent on another field. The initial code I wrote by instinct was very similar to what is suggested here, but instead of only disabling those controls which are marked as "child", it disables all of them - in effect, it seems only to be looking for the value of the last record and affecting all the rows.
Is there a way this can be achieved, or am I barking up the wrong tree? Code below:
If Me.Record_Type = "Child" Then 'Disable subsidiary records
Me.Record_Type.SetFocus
Me.Prospect_Name.Enabled = False
End If
Solution
The only way of sensibly working with rows in a continuous form is with Conditional Formatting. Any code applied refers to the active row, and so it appears to affect all rows.
Conditional Formatting, Access 2010
Enable / Disable is selected
- How to extract the schema of an Access (.mdb) database?
- Manipulating an Access database from Java without ODBC
- How to overlap microsoft access - report detail section layout to the previous one to avoid extra rows?
- What can trigger MS Access autoexec vba macro?
- Import recordset from Access to VBA ListBox
- Check if access table exists
- MS Access: There isn't enough memory to perform this operation (Reports)
- How to pass an array to a function in VBA?
- Getting "Too many parameters for command", when calling WinSCP command-line from VBA
- MS-ACCESS Difference between TempVars and TempVar
- Create a MS Access Pivot Query that returns rows even if there are null values
- Microsoft Access SQL is clipping a string when using INSERT to add a record
- Exporting a query result into a text file using vba-MS Access
- VBA referencing external module in .accdb database "tantrum"
- Is there a shorter way of appending information to an existing string?
- How can I automatically update the data in a record when I create a new record in a different table?
- ODBC driver for MS Access seems missing (Windows 64 bit)
- Access is multiplying my query count by 38.... why?
- VBA "does not equal" code not stepping through IF statement as expected
- Issues with Uploading Files to Azure Blob Using WinINet API in VBA (Error 12031)
- Splitting a full name string into First, Last and Middle Initial in VBA Access
- SQL string throws "External Name not Defined" error when running in VBA module - Name is defined
- How fast is SQLite compared to Microsoft Access MDB?
- SQL query left join with sum,group by and order by in MS Access
- ms access negative page numbers
- Number of users to a webpage
- How to get an item value from JsonObject
- Microsoft Access and paging large datasets
- Delete VBA module
- Access VBA For Loop throwing error of "No Current Record" after 1 iteration of code