Results 1 to 3 of 3
  1. #1
    FL0XN0X is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Belgium
    Posts
    84

    Enable only textfield of 1 record in Continous form

    Hi,
    I have a continuous form as a subform. Every record has a Edit command button that, when pressed, will enable the record fields (which are disabled On Load of the form). But my code enables ALL the fields on the form and not only the matching fields in the record I've clicked the button of.
    How can I refer to only the relevant fields in the record where I pressed the button?

    My current code:

    Forms![Mainform].[Subform].Form![Field1].Enabled = True
    Forms![Mainform].[Subform].Form![Field2].Enabled = True

    Thank you in advance.
    Kind regards,


    Bart

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    AFAIK you can't.
    You can disable the entire form or individual fields BUT ALL records are affected.
    If you ENABLE a field or all fields they are ENABLED for all records.
    This is by design.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    FL0XN0X is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Belgium
    Posts
    84
    Thank you ridders52.

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

Similar Threads

  1. Lock/unlock current record in continous form ?
    By Lukael in forum Programming
    Replies: 5
    Last Post: 02-17-2016, 01:04 PM
  2. Replies: 16
    Last Post: 02-13-2016, 10:21 AM
  3. Replies: 2
    Last Post: 04-29-2015, 09:37 AM
  4. Replies: 1
    Last Post: 10-20-2013, 06:37 PM
  5. Replies: 1
    Last Post: 01-26-2012, 05:15 PM

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