[sthomp04]

Please help. I am having a problem when trying to create a new record. Please see the attached Database and let me know where in the code I am having this problem and how to change it.

[CraigCKlein]

Hello,

You are going to have to be a little more clear. Please say something like:

In this database, form-xyz, control - btn_add, event- on_click

I am not sure where to find your problem to even begin to tell you where you may be going wrong.

Craig

[sthomp04]

Ok, I apologize. There is only 1 form and 1 main table (a few lookup tables) with 2 reports. The problem is in the fTabTransaction form when trying to add a new record by using the record navigation buttons. Sorry for not being more specific. Most of the code in the Calculations module deals with business rules to calculate a score but it keeps erroring on my use of a recordset.

[CraigCKlein]

Well,

I see a lot of things that I don't really like:
1. You should use Option Explicit at the begining of every module. This forces you to declare ALL variables.
2. I don't see why you need the recordset object if you aren't actually doing anything with it. On a new record the recordset does not contain the New record until you save it.
3. If you do need to use Recordsets for the bound Recordset of a form use the RecordsetClone method of the Form Object (e.g. Set rs = me.recordsetclone "or Forms(strFrmName").recordsetclone). (see help for more details). This will also help you to keep the navigation straight with bookmarks.
4. I just think you are over complicating things here. Maybe I just don't understand what you are really trying to accomplish. But it seems to me you don't need to use a recordset in your CalculateDocDefects. I would recommend passing the form object to this procedure and then it will know exactly what you are doing.

use: Sub CalculateDocDefects(fTabTransaction As Form)

then in the procedure using fTabTransaction will always point to the record you are working with.


I hope this helps.
Craig