K
Kate
I have a database that updates price information. Currently, it is set up to
prompt the user for the P.O. # and new price it wants to update.
Additionally, I have created a macro that runs the update query and sends an
email to the user showing the updates made.
The problem I am having is that often the user will be updating anywhere
from 5 to 25 prices for a particular site (we have 5 plants). The P.O. #
format is, for example, W050642K, where W = SiteID, 0506 = mmyy, and 42k =
material grade.
I want to create a form that allows the user to select the SiteID, and MMYY
and then can select MULTIPLE material grades to create the table that the
macro sends.
Any suggestions?
prompt the user for the P.O. # and new price it wants to update.
Additionally, I have created a macro that runs the update query and sends an
email to the user showing the updates made.
The problem I am having is that often the user will be updating anywhere
from 5 to 25 prices for a particular site (we have 5 plants). The P.O. #
format is, for example, W050642K, where W = SiteID, 0506 = mmyy, and 42k =
material grade.
I want to create a form that allows the user to select the SiteID, and MMYY
and then can select MULTIPLE material grades to create the table that the
macro sends.
Any suggestions?