"Object Required" error in Access Form 5

[BYarn]

I know this question may be too general but here goes. I Have an Access 2000 form. When the account # field is completed it will pull data from an exisiting table to automatically complete three other form fields from the record of the person with the account #. After that there are a few drop down boxes which are completed manually. All of the data ends up in another table.

When I click the SAVE button to store the data, I get an "Object Required" error button that pops up. I have to cancel out and no new data goes to the table.

My question- can anyone point me as to what kinds of things to look for that might eliminate the erro and allow the data to be stored. I have spent hours looking over the code and testing to no avail!! Thanks

 

[BYarn]

I am not at my PC w/the project now, but an update- I have (with everyones' help) gotten by the error generated by the save button.. But (as I was leaving) now I have a few fields not being written to the table holding the new data. I will try the last suggestions in AM and advise. Thanks!

Just a comment to jadams0173 -"The folks at Tek-Tips are here to help and not try to cause harm" Yes I am fully aware of that and it had nothing to do with my hesitancy in posting code, etc. I have never seen such a great group of people sharing of themselves and helping!!

 

[jadams0173]

Point taken BYarn. My comment didn't come out the way it was intended...

Sorry.

I tried to have patience but it took to long! -DW