Prev: Need help with tables
Next: Custom Popup toolbar
From: Rainman1960 on 19 May 2010 17:30
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
From: Jeanette Cunningham on 19 May 2010 17:44
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


"Rainman1960" <Rainman1960(a)discussions.microsoft.com> wrote in message
news:EFAB2E18-2F62-4C1C-B790-2CE6D6E2763D(a)microsoft.com...
>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


From: Jeanette Cunningham on 19 May 2010 19:07
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

"Jeanette Cunningham" <nnn(a)discussions.microsoft.com> wrote in message
news:e8dkCy59KHA.5848(a)TK2MSFTNGP06.phx.gbl...
> 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
>
>
> "Rainman1960" <Rainman1960(a)discussions.microsoft.com> wrote in message
> news:EFAB2E18-2F62-4C1C-B790-2CE6D6E2763D(a)microsoft.com...
>>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
>
>


 | 
Pages: 1
Prev: Need help with tables
Next: Custom Popup toolbar