Recent content by jeffjohnson29

I would like to add a button on the header of a report that will filter the text on the open report by what is in a control text box. Below is what I have tried but it is not applying the filter correctly and I am unsure of what I am doing wrong Private Sub btnFilter_Click() DoCmd.SetFilter ...

For my case the subform is essentially a keyword search that will list records with limited details that meet the search criteria. In the search subform the records are set to not be able to be changed and in the main form you have to click save before the record is updated. hopefully this...

I don't necessarily want another button to fill fields in a form, I don't think it would look all that good. I assume I could still use the code except for button on_click i would change the sub to form_dblclick. the form is already open so I am unsure if the docmd.openform is correct to use...

I have a form with a subform in it that keyword searches for records in a table that tracks assets. What I would like to do is be able to double click on the record selector in the subform and have it open the record/fill in the controls in the main form. I know I need to set the event on the...

Thank you! This seems to have been the problem. When I created a new Database and copied all the tables, fields, and Macros over the search worked correctly outside of the subform.

...okay then yes it is...

in the accdb that I uploaded first the "txtTerm" and the "btnSearch" are in the subform and it will search properly there. When I move it to the main form and use the vbs script in my initial post it errors out stating"The expression On Click you entered as the event property setting produced...

I am really new to building access databases and using vbs and I have watched the how to from steve bishop on how to create a keyword search using subforms but for some reason it does not work for me and I am unsure where my mistake is. I have been able to get the search to function inside the...