Transferring Data from one query to the next

[Julius]

I have two forms based on the same table, one is view closed inventory and
the other is view open inventory. Recently I put a command button on the
closed inventory form that will allow the closed inventory record to be
reopened. I need to put a condition in closed inventory query that when the
checkbox is selected for reopened, it will show that record in the open
inventory query. I have no idea how to do this. Please help I have a
deadline to meet. Any help would be greatly appreciated

 

[John W. Vinson]

I have two forms based on the same table, one is view closed inventory and
the other is view open inventory. Recently I put a command button on the
closed inventory form that will allow the closed inventory record to be
reopened. I need to put a condition in closed inventory query that when the
checkbox is selected for reopened, it will show that record in the open
inventory query. I have no idea how to do this. Please help I have a
deadline to meet. Any help would be greatly appreciated

If the queries just use the checkbox as a criterion, simply Requery the other
form in the afterupdate event of the first form. See the VBA help for Requery.

 

[Julius]

Not sure what your answer implies. Which would be considered the 1st or 2nd
query. Secondly, I have no way of telling access to move a record from the
view all issues closed form to the view open inventory, can you be a little
more specific on how I am to do this.