Need Help With a List Form

[Bears84]

Well I've tried several things to no avail. Maybe someone can see what I’m unable to see. My form frmAddSpool keeps giving me an error message. And i don't know what it’s looking for.
Maybe someone could look at this and give me a hand figuring it out.
I have attached a copy of my data base for reference.

 

[ShaneMan]

Well I've tried several things to no avail. Maybe someone can see what I’m unable to see. My form frmAddSpool keeps giving me an error message. And i don't know what it’s looking for.
Maybe someone could look at this and give me a hand figuring it out.
I have attached a copy of my data base for reference.

I can try to help here. I opened your DB and the error that I'm getting is a compile error. In your code your telling the recordset to AddNew using this:

rst1!SpoolID = Me.SpoolID

There is not a control named SpoolID on your form so your getting a compile error because it can not find a control by that name. From what I can see SpoolID is not there cause the forms Record Source is based off tblSheetNo and not off of tblSpool, therefor no SpoolID. I also noticed that your tables have several indexes set up. Did you mean for these fields to be indexed?

HTH,
Shane

 

[Bears84]

I really don't understand why it doesn't work like the Sheet form. The best I can tell it should. What would I need to do to get it to. I'm not very good at this VB thing and understand even less. So when I get these errors I'm lost. You had ask about the indexes that is the only way I no to get the items to lock together so that there is a treeing effect starting with Project then Line then Sheet Then Spool Then there will be Weld Numbers with all being unique to a project. But I'm all ways open for suggestions.