Recent content by ashleymac

Thank you @Gasman! I appreciate all the time you put into helping me out.

Pat - Thank you! That actually made sense to me and better yet it seems to have worked! I appreciate everyone's help and time. Have a great day! :)

So I've been recreating the form as @Gasman suggested and testing step by step. This code suggested by @Pat Hartman yesterday works as expected (saved records can't be accidentally edited but new records can be created).... Private Sub Form_Current() If Me.NewRecord = True Then...

Spoke too soon. Now I'm getting this error. I should note that I do have all the various fields set to Required at a table level to ensure my data entry guys can't skip out on adding vital information. Will this interfere with the .Dirty VBA?

@Josef P. That seemed to do the trick! Thank you!! If you don't mind - can you tell me why that fixed the problem incase I run into something similar in the future?

@Gasman Thanks for your help on this. I tried making just a simple form and it does seem to work. So I'll try remaking the form from the ground up and hope that works. Hopefully I can keep the same type of formatting and functionality as the original. :)

I have an admin form (that certain members of my team can access) that will allow edits to fix any mistakes that happen or fix missed types. I wouldn't just leave incorrect data without it being corrected.

Do you know if there is a setting I could have accidentally hit that makes alternate odd/even records some how? Or would it have more to do with 1 & 3 being Pass in the Results combobox and 2&4 being Fail?

I copied and pasted your original code exactly how you put it in your response. I saved it. Closed the VBA screen. That look me back to my form in Design View. I saved my form for good measure and closed the form. Then I re-opened the form. Clicked on a text box located in the first...

My apologies. When I'm looking at the code and such I just right click on the login screen and close it. You can use username: doejane pw: dog The specific form I'm having issues with is "frmRecordKeeping" You can get to it after the login screen Forms > Results Again I apologize for the...

@Gasman realized that was a dumb question as soon as I asked it. DB attached.

Do you need tables included or just the Forms?

I know that I'm doing something wrong. I just don't know what. Below is all the code that is on the Form in question, including the code Pat suggested earlier in this thread. I am very much a novice with VBA so I've been kind of piecing things together through Google and reading threads here...

I tried your code and it is still allowing edits on previous records. Any other ideas?

I have a Form that my team uses to enter test results. What I would like to have happen is once the results have been entered my team can go back and look at previous records but not be able to change them while still being able to add new records. I've gone into the Form's properties and set...