Event Procedure Prompts for Input But Code Does Not Reflect This

[cross]

All -

I've been working on a database that was created in 1999 - it has since been converted to Access 2010 (.accdb). The main form has several buttons that, when clicked, execute a macro (OnClick = [Event Procedure]). Some of the procedures prompt a user to key in a value (numerical, string, or both) before displaying a form with data filtered by the values that were keyed in by the user.

When I view the code for the Event Procedures attached to these buttons (in the Visual Basic environment), I do not see any commands that prompt a user for input. I'm expecting to see a MsgBox or InputBox somewhere in the code but I do not.

Example, the following is the procedure for a button that, when clicked, the user is asked to: "Enter the initials of the Rep Engr" before the form opens and displays the specific records for the person with the initials keyed in by the user:

Private Sub Button44_Click()
On Error GoTo Err_Button44_Click

Dim DocName As String


Dim LinkCriteria As String

DocName = "Tooling - CDI Schedule"
DoCmd.OpenForm DocName, , , , , acHidden
Forms![Tooling - CDI Schedule].RecordSource = "Tooling - Active Programs By Rep Engr"
Forms![Tooling - CDI Schedule].Visible = True
Forms![Tooling - CDI Schedule].Caption = "Active Tools By Rep Engr"

Exit_Button44_Click:
Exit Sub

Err_Button44_Click:
MsgBox Error$
Resume Exit_Button44_Click

End Sub

Concern:

I do not see any code where "Enter the initials of the Rep Engr" is set as the display text of the input box. Am I missing or overlooking something? Where can I find the code/the settings so I can eliminate the prompts or at least modify the text in the prompt's message?

[ItsMe]

Maybe there is a parameter in the query object named, Tooling - Active Programs By Rep Engr

[June7]

As ItsMe points out, dynamic parameters in query can trigger input popups. I never use them. Here is example of dynamic parameterized query http://www.datapigtechnologies.com/f...earchform.html

[cross]

@ItsMe - Thanks for pointing me in that direction - you are correct, the query object did have [Enter the initials of the Rep Engr] as a criteria.

@June7 - Thanks for the link! It seems I still have a lot more to learn about using Access, in general. I don't think I would have used dynamic parametrized
queries either but I guess it worked best, at the time, for the database creator :-\

Thanks for your quick responses, I'll mark this as Solved.