Filling in data to the selected field

[EMILYTAN via AccessMonster.com]

Hi everyone,

Initially I can work with the code below...
But I want some modifications.

Below is the output I want...J0001(OLD) WHILE J0002 (NEW)

Before :-
Bil (pk) JobNumber PartNumber RequiredQty
KittedQty
1 J0001 A1 1
1
2. J0001 B1 8
6
3. J0002 B1 8


After:-
Bil (pk) JobNumber PartNumber RequiredQty
KittedQty
1 J0001 A1 1
1
2. J0001 B1 8
6
3. J0002 B1 8
6

So, basically I just want to copy the KittedQty from the old to the new job
of kitted quantity if there is same partnumber exists in both job number...

In this case, I want to copy the kitted qty for PartNumber B1 (J0001) TO
JobNumberNew(J0002) TO Kitted Qty
and ignoring the A1....
Note: All of this data involve only 1 table

 

[EMILYTAN via AccessMonster.com]

Hi everyone,

Initially I can work with the code below...
But I want some modifications.

Below is the output I want...J0001(OLD) WHILE J0002 (NEW)

Before :-
Bil (pk) JobNumber PartNumber RequiredQty KittedQty

1 J0001 A1 1 1

2. J0001 B1 8 6

3. J0002 B1 8

After:-
Bil (pk) JobNumber PartNumber RequiredQty KittedQty

1 J0001 A1 1 1

2. J0001 B1 8 6

3. J0002 B1 8 (6)

So, basically I just want to copy the KittedQty from the old to the new job
of kitted quantity if there is same partnumber exists in both job number...

In this case, I want to copy the kitted qty for PartNumber B1 (J0001) TO
JobNumberNew(J0002) TO Kitted Qty
and ignoring the A1....
Note: All of this data involve only 1 table

[/QUOTE]

 

[Guest]

Have you tried using an update query when a new record is entered?

 

[EMILYTAN via AccessMonster.com]

Nope...I dont have the idea of how to make it work...

Have you tried using an update query when a new record is entered?

Hi everyone,

[quoted text clipped - 31 lines]

[/QUOTE][/QUOTE]