Search results

Yea it seems you're right. I added an input box to get the user's notes when they click the button. Ends up doing the same thing but feels more clunky that way. Either way, it works. Last thing is to make the record not enabled. This is important because I want the user to be able to mark...

Is there no way to make a control editable? For instance, I have a text box for the notes. It's not bound to anything, and I want to be able to type a note into the box before clicking "Mark as fixed" but when I do this, the text I add is removed when I click outside that textbox. I have a...

For that last issue, I realized it was a simple text problem. I needed to add single quotes to the variable, so: WHERE [key]=" & rcdKey & ";" became WHERE [key]= '" & rcdKey & "' ;" But now I need to determine how to set all the controls for that record on the report to "enabled = false"

I'm sorry, I'm not trying to lock the records before opening the report, I'm trying to use the button in the report to lock records. I worked a little on it a little and decided to use an Update query to try and update a single record's Notes block to "test", but I'm getting a strange issue...

Greetings all, as the title suggests I have a report that I would like to use to lock out records. Reports are not an area I have a lot of experience in yet. A little background: The purpose of this database is to check for data errors. The report specifically provides a list of all the errors...