RE: Add new record to subform based on condition - URGENT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I need to point out the if I can find a way for a new record to be added to
the subform and enter the value into fldSplitNo - then i can use that
condition to enter the rest of the data.
--
Cheers


"Cadburys" wrote:

Hi all

I am posting this the the Forms and Macros pages:

I have two forms:

frmJobCard1 - Main Form
frmSplits - Sub Form

On the main form I have the following 3 fields repeated 9 times (I know that
may not be perfect but I need them to search)

fldSplitDuration1 ..... fldSplitDuration9
fldTypist1 .... fldTypist9
fldProofreader1.... fldProofreader9

On the subform I have these 4 fields (of many others)

fldSplitNo
fldSplitDuration
fldTypist
fldProofreader

What I need is a follows: (Using a macro if possible)

When a value is entered into fldSplitDuration1 then go to the first record
of the frmSplit, enter the value 1 into fldSplitNo and enter the
SplitDuration1 value into the fldSplitDuration on frmSplits.
When a fldTypist1 has updated then go to frmSplits then go the the first
record of frmSplit for the related record and enter the fldTypist1 value into
the fldTypist on frmSplits.
The same for fldProofreader1.

Now I have it working for the first row. But if the user enters a value
into fldSplitDuration2 then I need the focus to shift to the frmSplit add a
new record and enter the value 2 into the fldSplitNo.
When a fldTypist2 has updated then go to frmSplits then go the the second
record(using if fldSplitNo = 2 then) of frmSplit for the related record and
enter the fldTypist2 value into the fldTypist on frmSplits.
and so on.

There can be up to 9 new records required - but sometimes on 3.

Please can someone help!



--
Cheers
.