Updating current record

[WithoutPause]

Database structure is out of my hands. Trust me, there was a face palm moment when I found of how it was set up. A user can log on and then click on a button to add a new record which gives between 1-3 types of records to add. There is another button to search for an existing record and again, the user gets to pick which type of record they want to search for. Why the search forms ended up using two forms was part of another thread I have on here. I have tried testing the database on two different PCs, and it works on neither although it should have been working on the main one at one point. I don't know what got changed that prevents me from adding or editing anything.



EDIT: Since I run it off an external HD, I tried copying it onto the PC, and it still merely adds a blank record whenever I try to enter data.

[John_G]

Hi -

Your Findfirst is wrong. Instead of rs.FindFirst "[C01] = C01" it should be rs.FindFirst "[C01] = 'C01' ". Because C01 is a string value, it has to be in quotes.

John

[ItsMe]

I am thinking it is a control name
https://www.accessforums.net/access/...tml#post210047

[June7]

Reference to variables should not be within quote marks. Reference to control as a criteria parameter is a variable.

rs.FindFirst "[CO1]='" & Me.C01 & "'"

[ItsMe]

Well, I am still learning...

[WithoutPause]

I ran Compact & Repair on your db and it went from 4992 KB to 780 KB.

I go into Access and then open the database in question. I do a Compact and Repair and I get nowhere near the drop in file size that you are getting. I'm guessing the issue is the database got jacked, and I'm not repairing it like I should be.

[June7]

That's odd. I downloaded your db again and did the C&R again just to make sure, same results.

[WithoutPause]

I rebuilt the tables and the application works. I still don't get any real drop is file size when using C&R, and I tried on two different versions of Access 2013. I am at the point where I am converting it over to a accbd file, and I got an error message so I'm going to go complie it and see once that runs clean if the C&R performs differently.