Setting a value on a bound subform field

H

HSalim

Hi,
I'm using Access2000
I'd like to set the value of a field in a subform but am getting Runtime
Error 438 - Object doesn't support this property or method

Dim rs as DAO.Recordset
set rs = Forms!frmShipments!sbfCartons.RecordsetClone
rs.MoveFirst
while not rs.EOF
rs.Fields("Class") = 1
rs.update
rs.movenext
wend
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is wrong? Can you interpret this for me? 5
Form data not refreshing after editing 1
Using "tiles" 1
MSAccess 2000 -- Error 91 problem 7
SelHeight 2
Data passing thru the fields of the header 0
compile error: For control variable already in use 1
traversing a large recordset 4

Top