Search results

I got to work quick and can confirm it is working everywhere. I appreciate the help. Is there a way to code a button to open the same form (Update_Form) and have it ask for a parameter (a report number)? I'd like to purge a few more forms if possible. Thanks again!

I got it to work! Screwing around I change it from the field names to the name of the field in the table "Report_Number." It now works. Is there a way to get this to work if one of the fields is in a navigation form? I'd like to double click a report on the home screen to open the same update form.

This is the new code: Private Sub NSRIReport_Number_DblClick(Cancel As Integer) DoCmd.OpenForm "Update_Form", , , "UFReportNumber = '" & Me.NSRIReport_Number & "'" End Sub Same issue, parameter window asking for UFReportNumber. What does using delimiters mean? I can attached the database, but I...

It is; both fields are the report number, but I gave the fields unique names so I could write the code easier. The field is returned by the query. The field in the table is formatted as short text.

I added a record source, a query with no criteria. It now opens a parameter dialog asking for UFReportNumber?

So I created a new update form that does not have a record source. I then went in and created some unique names and added this to the on double click: DoCmd.OpenForm "Update_Form", , , "UFReportNumber = " & Me.NSRIReport_Number When I double click a parameter dialog opens asking for the report...

I have three split datasheet forms in which users can double click a request number to open an update form (each split form is a filter for different tables). Each split form has a related update form. The source of the update form is a query. (Three split forms, three update forms, three update...

I got it working. Thank you for your help.

I added the button to the search form that opens as a dialog. I read that dialog windows can cause VBA to not run, so I now have it opening as a regular window. Same issue. I will need to upload it with the tables removed. They contain confidential information. I also had to remove reports to...

I added your code to the "on click" event of a button. I received this error: Run-time error '2585': This action can't be carried out while processing a form or report event.

I request help in creating a macro that: Close a form opened as a dialog window. Open a subform/control in a navigation form. The navigation form is open behind the dialog window. Objects are named: NS_Request_Info (dialog window). New_Request_All is the subform/control I want to open after...

I get what you're saying with the tabs, I have that setup for several entry forms. I still can't get this to work. I figured a fair solution would be to just have a custom dialog form open if the condition is met. I'm not great a VBA, so attempted an OpenForm macro on the "on open" event. I used...

I originally built it as a sort of launch pad (form with a bunch of buttons), but the amount of windows confused everyone. I've designed it with the lowest common denominator in mind, which is pretty low.

I'm realizing how annoying they really are. It was a pain in the ass to get simple things to work, like save buttons and and certain queries. I entered that code in the "on click" event, and it returns an error on the report number.

The button that opens the form is a navigation button. Can I add it to the "on click" event to a navigation button?

Put this in the "on open" event?

What I failed to mention is the button is a navigation button on the main form. The update form opens as a subform after the report number is keyed.

An update form opens with the attached query. The form opens with empty fields if report_number has a "true" research_request. I want this to happen, but I'm worried this will confuse users. Is there a way to stop the query from running if research_request is true?