Form locked up from data entry

[KahluaFawn]

frm CSMMembers and frmCSMMembers NEW are both set as DATA ENTRY = YES

that is why you don't see any records.

I changed that this morning when it didn't work, hoping that would help. I guess I don't understand what I changed. Would you please clarify? Thanks.

 

[ajetrumpet]

Lets get back to the original question...what do you need these two forms for??

JUST updating field values??

I see nothing wrong with your database actually.

 

[KahluaFawn]

Yes, I just need one of them to work. I still have the original data base which I simplified trying to get to a solution ... and this solution does not fix the original data base. I will up load that one now.

The form is frm CSMMembers. This is where the data displays but can NOT be updated. Thanks.

 

[ajetrumpet]

I CAN update values in the frmCSMNew, but not in the original one. I see that the querying is exactly the same for them both. Can you not update the values in the new form??

 

[ajetrumpet]

This is what I am able to do with your database Kahlua...

1) The FORM "frmCSMMemberNEW" IS updateable (but it's query is not), and those updates are reflected in the underlying query and source table.

2) The FORM or query "CSMMembers" is NOT.

I looked through and everything looks the same to me.

Another thing is that the query frmCSMMembersNEW is not updateable, but the form is. Maybe you're query is borderline "too complex" to be evaluated. I would say that, or maybe you've got a bit of corruption...

You said something about sorting the records in the query and that caused this. How did you do that?? Both of the queries are sorted by two fields, via the grid.

 

[missinglinq]

Being simple minded, when I flip a switch on a piece of equipment I usually just flip it back. Since sorting the data in frmCSMMembers made it non-updatable (which it was when I opened your original db, which is to say the last one you posted here) I went in and re-sorted by the LastName field and, voila, the form is now updatable again, with changes made being reflected in the underlying table/query! Of course, this doesn't explain why sorting scrooched the pooch, but it does make it usuable again! As John Walton used to say, "Life's a mystery!" and god knows Access is! Speaking of mysteries, I don't understand how the form and table can now be directly updatable but the query still isn't!

I also re-sorted on a number of fields and the form remained fine. What field did you originally sort on that messed things up?

Linq

 

[KahluaFawn]

sorting frm

I sorted the form's LastName column "ascending" but it didn't make any difference with the ability to update records. So then I sorted "descending" and immediately resorted "ascending" and now I can update the data in the form.

I've been using this MDB file for several years without any problems ... until now. Thank you to all who have helped me get back to where I can use the database again (I'm going to try to add new records to it now). I only wish that I could understand what actuall happened to Access's logic with that disruptive sort I did ... but I guess the mysteries in life are what keeps us searching onward to new horizons. THANKS AGAIN!!!! You all are GREAT!!!!

 

[boblarson]

I've been using this MDB file for several years without any problems ... until now. Thank you to all who have helped me get back to where I can use the database again (I'm going to try to add new records to it now). I only wish that I could understand what actuall happened to Access's logic with that disruptive sort I did

Just an FYI about this. Unexplained things like this can be a signal that corruption is starting to appear and you might look into creating a new, blank mdb file and then import everything into it, reset the startup options and then go from there. Since you said you've been using this for many years without problem, that would lead me to believe that it could be a little corruption creeping in.

So, just a suggestion, but actually it's probably a good thing to do every once in a while anyway as there are things within the db file that have lifetime limits and importing into a new mdb file can reset many, if not all, of those.

 

[KahluaFawn]

importing into blank database

I've not done this before. Is there a good spot on your forum (FAQ?) that can help get me started with the process? It definitely sounds like the way to go with my application! THANKS.

 

[boblarson]

 

[KahluaFawn]

Thank you so much for your visual aids! I am printing them now and will rebuild per your directions. I am truly impressed by the talent and dedication of the members on this forum. Thank you all.

 

[boblarson]

Oh, I forgot one more thing about the Startup options.