Having to re-enter a parameter for a select query to print a report from an open form

[June7]

And the means to accomplish that have been described.



If you really prefer a dynamic parameterized query then the parameter would be a reference to control on form. As long as that form is open, there will not be a popup input prompt.

However, might find this interesting http://allenbrowne.com/ser-62.html

[Micron]

You have been given at least 3 simple workable solutions for this, at least one of which was supported by someone else.
The first suggestion requires you to base your report on a similar version of the query but without the parameter. Then apply a filter to the report when the report opens. The filter value comes from the open form.

You haven't indicated a preference for any of them, nor mentioned whether or not the form stays open even though there was/is speculation about that. You need to go over the replies again and decide on which method you prefer and we can assist with that. Appending or updating any field so that you don't have to enter the parameter again is not only unnecessary, it has the potential to conflict amongst concurrent users as mentioned. If you don't know which method you want to employ, research "MS Access apply report filter" and "DoCmd.OpenReport method" and note the use of both the OpenArgs and Filter properties of the OpenReport method. You might also want to look up "ms access report record source using vba sql"

[Roncc]

I thank you all for your time. I'm a novice at this and frankly, my knowledge of Access is too limited to understand much of what has been said. I have, however, come to understand that I should not proceed with the use of an update query to change data in the table as it will cause problems down the road and for that I am very grateful. I don't believe it is your job to teach me Access basics so I will review what you have said and do additional research.

Thank you again.

Ron

[orange]

I recommend you read this FMS article(s) and get a clearer understanding of Access database and multiple users.