Darren DICK
d.dick at uws.edu.au
Tue Jan 20 23:17:35 CST 2004
Hi All
This should be simple
I have some code updating a table of records
Dim selSQL As String
Dim rs As Recordset
selSQL = "SELECT tblMyTable.* FROM tblMyTable;"
Set rs = db.OpenRecordset(selSQL, dbOpenSnapshot)
With rs
.Edit <===Code Fails Here
!MyField = Me.txtMyControl
.Update
End With
The rror I get is...
Error 3251: Operation is not supported for this type of Object
Any suggestions??
Many thanks
DArren