Search results for query: *

I have a subform where I want users to enter notes regarding the current record on the parent form. The subform is a continuous form. In the header of the subform I have a button to add a new note. The click event of the button sets AllowAdditions = True, performs AddNew on the subform's...

Yeah, you would think that would work, and it did work when the form's record source had records, but when I changed the record source so that it would not have any records when the form loaded, then I got the 2185 error "you can't reference a property or method for a control unless the control...

The value property doesn't work for me because, in my scenario, the value has not been updated yet. I want to have a search button that is enabled only when a textbox contains search criteria and disabled when the textbox is blank. Using the MS Forms textbox didn't take much effort.

I found a way to work around this. If you're using a textbox strictly as an unbound textbox you can use the Microsoft Forms 2.0 textbox instead of the native Access textbox. Then you can reference the text property without a problem.

What do you do when you need the text property, for example you want to enable a button if there is text in the textbox and disable the button if the textbox is blank?

OK, that works. I had to add some code for the instance where the textbox is null, because I'm using a string variable. Thanks.

I'm altering the SQL statement in the form's record source. I can change the SQL statement so that no records are returned on form load. The bound controls are hidden, which is fine. But then the unbound textboxes with the search criteria don't work. I get the "you can't reference a property...

I have a form with unbound text boxes and a search button at the top, and then the rest of the form has bound controls. The problem is that the query (selecting all records) that is the recordsource of the form has gotten big so that the form takes a lot of time to load over a slow network...