Results 1 to 4 of 4
  1. #1
    Sck is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2010
    Posts
    82

    determine if row or column selected in Datasheet view

    how do i determine if a row or a column is selected in a datasheet view form? I have a form with a datasheet subform. when the user selects a row in the subform, the data on the main form is updated. this works fine BUT if the user selects a column (to filter or sort), which is the reason for using the datasheet view, the main form updates for all the rows. i want to catch if a column is selected instead of a row and not run the update process

    thanks!

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Sck is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2010
    Posts
    82
    thanks that is what i used as my base for the code when rows are selected. however, if you select a column to sort/filter all rows are selected and the code runs against every row. that is why i am looking for a way to see if a column is selected

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Use the record count, >1 then no updates.

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

Similar Threads

  1. Query column order - datasheet vs design view
    By fhickler in forum Access
    Replies: 3
    Last Post: 02-13-2019, 06:41 PM
  2. Replies: 3
    Last Post: 09-18-2015, 07:54 AM
  3. Grid Column Order in Datasheet view
    By apotter in forum Forms
    Replies: 3
    Last Post: 03-16-2012, 12:46 PM
  4. Replies: 2
    Last Post: 10-21-2011, 07:11 AM
  5. Replies: 1
    Last Post: 07-14-2010, 01:34 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