Transferring Data from one query to the next

  • Thread starter Thread starter Julius
  • Start date Start date
J

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
 
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
Click to expand...

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.
 
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.
 
Back
Top