Report Find Record Button

[data808]

I have created a Find Record button in one of my forms. I used the control wizard to make the find record button. The next thing I did was copied and pasted this same button from the form to my report and it works pretty nicely. So I did again into another report and then it didn't work. It has this error window that pops up. I can't remember exactly what the error message says because the file is at work but it had some kind of check box saying they can try fixing or debugging the database and at the bottom it had the options to send or don't send the error report to microsoft.



Does anyone know what may be causing this? It does work in the first report that I pasted the find record button in but not the second. I checked the macro conditions, actions, and arguments and they look the same.

[ItsMe]

The error you are receiving is your DB crashing. I would have expected an exception (error) if your macro did not work. The macro probably started and never stopped, causing Access to take over after a certain amount of time.

I try not to make two or more forms that are alike so copying code and or macros from one form to another won't work unless I adjust the code/macro to suit the new form. Perhaps you could just create a new control and macro.

[data808]

Ok. Thats actually what I wanted to do but found out that the button control wizard, for some reason does not pop up when creating a new button in a report. It pops up in my forms. Just not the reports. I messed with the control wizard button but still nothing. I don't really know how to make a find record button the way that I want without the wizard. I like it exactly the way the wizard creates the button for me where I can type a value for what it is I am looking for. And I can select parameters like whole field or any part of the field kind of settings. Do you know how to do this without the wizard? Or if you could tell me how to get the wizard working in reports that would be great. Thanks.

[ItsMe]

I don't use reports like forms so I am not sure what all of their capabilities are. Here is an example of using the value of a combobox to take the user to a relative record within a form's recordset.

https://www.accessforums.net/forms/e...tml#post208679

Let us know if that helps....

[data808]

Well in forms I haven't had a problem setting up a find record button because the control wizard actually pops up to help me set up the button. Not sure why it doesn't work in reports. Anyway I looked at the combo box link and I'm not sure if that would work with my database as I have thousands of records. Does the combo box search by me typing something in the box itself? Or is a drop down list of all the records and I have to click on the record I want to view in the form. If its that then I don't want to go through thousands of records to find the one I need to view.

[ItsMe]

You do not have to use a combobox to get user input. You could use a textbox, for example.

So if it is not a combobox or listbox you would not need to tell access what column to retrieve the value from.

rs.FindFirst "[cust_name] = '" & Me.ComboboxName.Column(0) & "'"

would be

rs.FindFirst "[cust_name] = '" & Me.TextboxName.Value & "'"

This assumes you are searching for a value in a field of text data type. You can also use wildcards to search the beginning of a field or end of field, etc.

rs.FindFirst "[cust_name] = '" & Me.TextboxName.Value & "*'"