form error

  • Thread starter Patrick Stubbin
  • Start date
P

Patrick Stubbin

I have borrowed from lebans the following code: for generating line numbers
and when i compile the code i get the error "method or data member not found"
it occurs for .Edit (see below),,,, i dont know what is happening?, also
this code is part of a report and the report now wont display, access does
not respond after a while and i have to use task master to close access. any
help is appreciated

The essential code is :
With rs
intAlias = 1
If Not (.EOF And .BOF) Then
.MoveFirst
Do While Not .EOF
lngEmpID = !Code
bytLevel = 0
.Edit
!ColumnAlias = intAlias 'assign alias A - whatever
.Update
intAlias = intAlias + 1

.MoveNext
If .EOF Then
Exit Do
End If

Loop
End If
End With
 

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

Top