Table to Form automatically

  • Thread starter Thread starter Rainman1960
  • Start date Start date
R

Rainman1960

I am manually changing inventory on a table and when I go below a certain
level I want it to automatically switch to the re order form.

Thanks
 
If you mean that you have the table open and are changing values in the
table, there is no way to make the table open the re order form.

Build a query using that same table, use that query as the record source for
a form.
Now you can try writing some code to open the re order form when the re
order level is reached.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Probably I should have included this:
Open the form you created and use it to manually edit the values in the
table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top