still problems with movelast

[rudeman76]

Hello again,

I have a table that once the user logs in, it adds the crews info (crew, date, and keeps track of numbers that the user adds during the day). It also has an autonumber. The problem I am having is that the addnew works great, it adds the user and their info. Problem is later on during the program, when the user adds info during the day, I open the recordset and change the numbers as the user enters the info (eg. number of bags, number of cans). This is supposed to be a running total throughout the day. When I open the recordset and put in rs.movelast, it only goes to like 10 records in and adds all the numbers on to that record. So the record gets all the numbers. It adds the numbers correctly and changes all the info needed to be changed, it just does not go to the last record. I do not know why this is.

Andrew

[NeoPa]

I'm not sure why you'd use MoveLast in your logic. Surely there is data in the record which identifies the one you need to update (uniquely). Is it even safe to assume all day that the record you want is necessarily still last?
This issue should never arise as you should always be specifying the record you're interested in.

[rudeman76]

actually i was just thinking the same thing after i posted it. Thanks

Andrew

[NeoPa]

No worries Andrew. Another easy one then ;)

[rudeman76]

You guys have no idea how much help you have been. And very quick at replies too.

Thanks alot.

Andrew