Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: Disabling one Record or one textbox on tabular Form

    Hi Everyone!
    I have a command buttons cmd_transfer on tabular form . WHen I click on transfer I only wnat to disable that unique record Instead of Disabling all the records. Can any one help how to do this ?

    Here is the code which locks this field in each record
    Private Sub cmdTransfer_Click()
    response = MsgBox("im locking the fields , Are you sure you wanna continue", vbYesNo)
    If response = ID_YES Then
    Me![Description].Enabled= false
    Else
    Exit Sub
    End If
    End Sub

    here is the snapshot
    [IMG]C:\DBSCreenShots\LockingProblem.jpeg[/IMG]
    Last edited by VBAPROGRAMMER; 12-11-02 at 17:58.

  2. #2
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Re: Disabling one Record or one textbox on tabular Form

    Originally posted by VBAPROGRAMMER
    Hi Everyone!
    I have a command buttons cmd_transfer on tabular form . WHen I click on transfer I only wnat to disable that unique record Instead of Disabling all the records. Can any one help how to do this ?

    Here is the code which locks this field in each record
    Private Sub cmdTransfer_Click()
    response = MsgBox("im locking the fields , Are you sure you wanna continue", vbYesNo)
    If response = ID_YES Then
    Me![Description].Enabled= false
    Else
    Exit Sub
    End If
    End Sub

    here is the snapshot
    Last edited by VBAPROGRAMMER; 12-11-02 at 17:49.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •