Updating Access table using DAO

[presence76]

I am attemtping to update a table in access from a value received from a form. When I run it, I get the following error : run time error 3265 - 'item not found in this collection. Below is the code:

Dim newmgmtcode As String
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb()

newmgmtcode = Forms![form1]![textmgmtcode].Value                 ' get new mgmt code from screen

Set rst = dbs.OpenRecordset("tblmgmtcodecurrent")
With rst
  .AddNew
  .Fields(1).Value = newmgmtcode
  .Update
End With

I have been searching this site for a while to try to solve this. I know it's something real simple. Any help would be appreciated. Thanks.

 

[Tanis]

What line does it error out on?

 

[presence76]

It errors out on the

Fields(1).Value = newmgmtcode

Line.

 

[Norie]

Remove Value.

 

[presence76]

Thanks alot for the info. Now, when I execute the form, I get
'invalid use of null' when I assign the value to the variable on this line:


newmgmtcode = Forms![form1]![textmgmtcode].Value

The strange thing about is that I had this problem earlier (before removing value) and I ran thru the debugger once and it worked, then I went out of debug mode, executed the form and got this. I tried to go throught the debugger again this time, and now it does not work either way.

Any ideas would be greatly appreciated.

 

[Norie]

Again remove Value.

 

[presence76]

I removed value from the form assignment lineline and got the same result.

line now looks like this:

newmgmtcode = Forms![form1]![textmgmtcode]

 

[Norie]

Have you checked that all the names are correct?

 

[presence76]

Yes, I double checked all that. Again, the strange thing about it is that it did work with the .Value at the end of it. But before I even changed the .value line on the table update, I had a problem with this. I thought maybe I had an odd setting on the textbox definition itself, but I checked all those as well. Is there something wrong with the brackets?