Error Message

[Eric]

When i try to run that method in my continuous form it gives error
message:
invalid operation
Here txt is the textbox which bind with the table tbl_Events

Private Sub Form_Load()
Dim qry As String, rst As Object
qry = "UPDATE tbl_Events INNER JOIN Tbl_EquipmentChronology ON
tbl_Events.TicketNum = tbl_EquipmentChronology.TicketNum SET
tbl_Events.txt = tbl_EquipmentChronology.Equipment1 WHERE
tbl_Events.PPVVOD_Outlet = Tbl_EquipmentChronology.Outlet;"
Set rst = CurrentDb.OpenRecordset(qry)
End Sub

Thanks,

 

[Allen Browne]

Eric, OpenRecordset() opens a SELECT query in memory, where you can walk
through the records.

Your query statement is an action query. Use Execute, or RunSQL.

For details, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html