Open a form through a query

[rdeleon]

Hello



I am working on setting up a report that references a query for data. The query requires the user to choose from a list of individuals to search. At this point the user must open the form separately before opening the report (or running the query). Is there a way for me to consolidate this into a singular step?

Thank you!

[JoeM]

Create a selection form, that has a Combo Box where the user choose who to search on. Then have a Command Button, that when pressed will update the SQL code of the query with that criteria (via VBA), and then open your Report (which is based on the query you just updated via VBA).

[rdeleon]

Thank you so much! I have another quick question if you are able to help.
After the user selects the individual to search, the report opens and everything works. However, by selecting the individual to search some of the data in the table is changed. The [Individual] column in the original data table updates the last entry to that name, even though that was not the original name in that slot. Is there a way to prevent this?

[JoeM]

That shouldn't been happening, unless there is a problem with your query (or perhaps you are running an Update or Append Query)?
Maybe if you post the code you came up with, we may be able to see if something sticks out.