Hey Richard and the Guys, I using a Continuous Form where I can Check-Out or Check-In Equipment using a Button. I was wonder if there's an way that I could Update to Table that the Continuous Form is not using to get Data From? Here's is the VBA Code that I have below:


Private Sub BtnCheckInOutEquipment_Click()

    Dim EquipmentID As Long
    Dim EquipmentStatus As String
    
    Dim U1 As String
    Dim U2 As String
    
    EquipmentID = DLookup("EquipmentID", "EquipmentT", "EquipmentID=" & Me.EquipmentID)
  
    EquipmentStatus = DLookup("EquipmentStatus", "EquipmentT", "EquipmentID=" & Me.EquipmentID)
  
    LastID = Nz(DMax("AssetUsageHistoryID", "AssetUsageHistoryT", "EquipmentID=" & Me.EquipmentID), 0)
    
    If EquipmentStatus = "Unavailable" Then
        U1 = "UPDATE EquipmentT SET EquipmentStatus = 'Available'  WHERE EquipmentID=" & EquipmentID
        U2 = "UPDATE AssetUsageHistoryT SET InStock = True, DateIn=#" & Now() & "# WHERE AssetUsageHistoryID=" & LastID
        BtnCheckInOutEquipment.Caption = "Check-Out"
        
        DoCmd.SetWarnings False
        DoCmd.RunSQL U1
        DoCmd.RunSQL U2
        DoCmd.SetWarnings True
        
    ElseIf EquipmentStatus = "Available" Then
        DoCmd.OpenForm "EquipmentCheckOutF", , , , acFormAdd
        Forms!EquipmentCheckOutF!EquipmentID = EquipmentID
    End If
      
    Me.Requery
    
End Sub

Also, I try DLookup the Data from the Table that I am trying to UPDATE....