D
Debbiedo
I have a form that will primarily be used as a data entry form for new
orders. Only occasionally will an order need to be modified.
I want the form to open up as if entering a new record. After they
enter the order number and move onto the next data entry box, I would
like the form to populate the fields with the data of the order should
the order exist, else continue entering data as a new record.
Problem is, I would like to limit access to the order data they are
currently using, i.e the order number they enter (I have my reasons,
trust me) and not be able to easily see additional orders from other
vendors. I can't control this completely, but making them enter the
correct order number to see only that data would help limit the
exposure.
Ideas as to how to approach this?
Not a big VBA person, but am learning slowly. Any and all help greatly
appreciated.
Deb
Am designing forms in Access 2003 but some Access 2007 users will be
using (and maybe, god I hope not though, earlier Access versions as
well.)
orders. Only occasionally will an order need to be modified.
I want the form to open up as if entering a new record. After they
enter the order number and move onto the next data entry box, I would
like the form to populate the fields with the data of the order should
the order exist, else continue entering data as a new record.
Problem is, I would like to limit access to the order data they are
currently using, i.e the order number they enter (I have my reasons,
trust me) and not be able to easily see additional orders from other
vendors. I can't control this completely, but making them enter the
correct order number to see only that data would help limit the
exposure.
Ideas as to how to approach this?
Not a big VBA person, but am learning slowly. Any and all help greatly
appreciated.
Deb
Am designing forms in Access 2003 but some Access 2007 users will be
using (and maybe, god I hope not though, earlier Access versions as
well.)