AllowEdits switching (true, false)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have command buttons (Edit, Save, Cancel) switch back & forth (to enable &
disable)

This was working great until I change my Record Source #1 to #2. The record
source is from the 2 tables and now the “cmdEdit†button is NOT working. If
I change the Record Source to #1 the “cmdEdit†is working. Any clue will be
greatly appreciated. Thanks.

Record Source #1
SELECT * FROM tblTESTS;

Record Source #2
SELECT tblTESTS.*, tblLOTS.orderDate
FROM tblTESTS, tblLOTS
WHERE (tblLOTS.prodNo=tblTESTS.prodNo) AND (tblLOTS.ItemNo=tblTESTS.ItemNo)
AND (tblTESTS.type=tblLOTS.type);

Private Sub Form_Load()
Me.cmdEdit.Enabled = True
End Sub

Private Sub cmdEdit_Click()
me.AllowEdits = True
End Sub
 
Instead of the 3 components of the WHERE clause, try an INNER JOIN on those
3 fields.
 
Back
Top