Table to Form automatically

[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

 

[Jeanette Cunningham]

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

 

[Jeanette Cunningham]

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