Both the master form AND the subform are read only. They are not update-able. The tick boxes are a part of the recordset of the subform recordset, as they are normalized attributes of the table.
I might as well add: I also want to modify a table field to become a weblink if another column (defined as a link) is populated. Any clue? I dont want to have a naked web address.
I have a Access 2016 DB. I am working on a Form that has a master/child relationship. This works perfectly. The subform works perfectly and loads the filtered rows as designed. The problem that I am tring to solve is that I have 9 Yes/No (-1/0) ControlSource fields. I am trying to relate each of...
I'm new, but cannot find an answer in the documentation.
I have a controling subform (DisplayOptions). It has 6 checkboxes that control which columns to display throughout the application in addition to the three default columns. What I want to have happen is that when a checkbox is checked or...
I have a query that is defined by date and Activity Level. It excludes any Activity that has already been performed for the selected date. I get the right esults returned. I only want the first three records returned. Does anyone know how to do this?
I have long lists in my combo boxes. I have already catorized the data as much as possible. I am looking for a solution that will use a dynamic LIKE clause as the user types and requery or filter the combo box. I have tried a couple of different things, but with no success. Help.