Replies

This is the last control on the form.. What the code does is update the current record and then using an Inputbox it prompts the user for a new groupid#.. Which is a field in a query. I’mnot trying to log anything just update the record.. Does the explain it better? The Me.RecordSource = BuildDataEntry() is module which is where the Inputbox part of the code is located. So BuildDataEntry needs to run to have the inputbox prompt the user. Should I be calling this another way? Not sure..

Charlotte thanks for the help.. I do not have anything in the On Open event to check for an empty string. How can I check for the empty string in the On open.. Not sure how to do that. Thanks again..

They want to store this in the underlying table of the form.. The form is generated from the table called Tracking data. The field they want to store it in is called. [Trackmain].. I’m not sure what they want to do with it at this point. They’ve been very vague. I just know they want to populate the field on the form and that form is part of the underlying table. I hope this helps Charlottle..

Ken your error handling works well.. But when I tried each of the new line of code you gave me it still gives me the same 2427 error “You entered data that has no value.” It has a real problem if the it kind find what you enter.. Any thing else we could try? Thanks..

Thanks that worked..

Thanks Rory. It was getting late in the day when I posted that.. I was getting pretty tired.. I hope you’ve been well and thanks again..

Could you force the key press using On Exit SendKeys, {Enter}? Not sure?

Thanks Charlotte.. I’ll check it out..

Thanks Charlotte.. That was it..

Thanks Charlotte

I got this fixed.. There was corruptionn in the MsysObject table.. I could not compact it the conventional way.. I had to ise microsoft’s JETCOMP utility.. Thanks for the help..

Thanks everybody.. The problem was my MSysObjects table was missing an index.. I used the JETCOMP utility from Microsoft to repair.. Thank god that worked!!

Sorry.. I’m using Access 97.. The database is not linked.. What I mean about the database working is it functions fine. The autoexec macro runs and it opens the main form and you can enter records in.. But when I close the Main form to view the underlying tables and forms etc. They are not visible.. There is nothing listed under table or forms or macros or anyhting.. When i hit the tab to view all the tables it tells me “Operation invalid without a current index.”

Thanks Scott.. I thought that might be it..

Thanks everybody I got it fixed.. I was telling it the parent form as you mentioned.. Thanks again..