B
bwaldrum
I have a reference table of material prices that I use to fill in a
Purchase Order in MS Access 2003 front-end linked to MS SQL Server
back-end. The purchase order uses the reference table to fill in item
name, descriptions, and unit prices for material, I want to be able to
update the reference table field "unitPrice" from the "Unit Price" text
box afterupdate event on the Purchase Order form. The Purchase Order
form is really made up of 2 seperate tables in addition to the
reference table spoke of above. Purchase Order line items table
records the change appropiately, but have not been able to find the
right coding to update the field in the reference table. I really
don't want to open up another form to do the same thing. This database
has up to 5 users, but only I have access to this ability.
Purchase Order in MS Access 2003 front-end linked to MS SQL Server
back-end. The purchase order uses the reference table to fill in item
name, descriptions, and unit prices for material, I want to be able to
update the reference table field "unitPrice" from the "Unit Price" text
box afterupdate event on the Purchase Order form. The Purchase Order
form is really made up of 2 seperate tables in addition to the
reference table spoke of above. Purchase Order line items table
records the change appropiately, but have not been able to find the
right coding to update the field in the reference table. I really
don't want to open up another form to do the same thing. This database
has up to 5 users, but only I have access to this ability.