[AccessD] Updating a value in a subform

Blank moment gone now

Need to do it using SQL statement.

Liam

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liam Meadows
Sent: 18 December 2003 15:07
To: Access Developers discussion and problem solving
Subject: [AccessD] Updating a value in a subform


Having a blank moment here

I have a form with a filtered subform (BomtypePForm) and in that subform
(BomtypePForm) are 2 fields (AS_PART_CODE and AS_QTY),
In the subform data are 4 records SCRAP, LABOUR, OVERHEAD and DELIVERY
along with there qty's.

I would like in VB to update SCRAP AS_QTY to a value, LABOUR AS_QTY to
another value etc..etc..etc..

How do I find SCRAP in field AS_PART_CODE in subform BomtypePForm and
update the relevent AS_QTY.


TIA

Liam
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com