Results 1 to 3 of 3
  1. #1
    Peter5164 is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2022
    Posts
    1

    Selecting Records by VBA in a continuous form


    I have a Continuous Form which displays all the sections of a document. What I want to do is have a function that Cycles through all the records and changes the colour of any which have entries (based on a comments table). I am struggling to find how to select the records and change colour. Any ideas would be most gratefully received.

    e.g. I want clients to select the comments they want for a particular section and he the continuous form set the colour of any section which has selected comments.

    Thanks

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    It sounds like you want conditional formatting
    https://www.google.com/search?q=micr...nal+formatting

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Whilst it would be by CF, I believe you would need to invoke the CF by VBA, so Google that as well.

    https://www.google.com/search?q=micr...t=gws-wiz-serp
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Selecting records in continuous form
    By sjolley in forum Database Design
    Replies: 6
    Last Post: 11-20-2017, 06:19 AM
  2. selecting specific records from table into sub form
    By Terry Sumpter in forum Forms
    Replies: 3
    Last Post: 12-19-2013, 06:37 PM
  3. Replies: 3
    Last Post: 05-15-2012, 02:51 PM
  4. selecting all records on continuous form using vb
    By Mclaren in forum Programming
    Replies: 13
    Last Post: 01-03-2012, 12:20 PM
  5. Selecting records within a form
    By crowegreg in forum Programming
    Replies: 29
    Last Post: 08-19-2011, 08:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums