28 Mar 12 9:51
This one has me really, really, confused. (and frustrated !)
This "mdb" is to track warranty claims received.
Table 1: tblClaimNumber, one field: ClaimNumber. Integer - defined as four (4) digits: 0001, 0002, etc
Table 2: tblWarrClaimLog 5 fields:
SEQ (number, integer)
On my data entry form I have ALL text boxes.
The LogNumber control (tbxLogNumber]is defaulted to a string of "WARR" & Year(Date()) & tblClaimNumber.ClaimNumber
The tblClaimNumber.[ClaimNumber] is sucessfully incremented when I leave the Comment text box, so the LogNumber changes for the next record
? I need to "copy" the tblClaimNumber.[ClaimNumber] value into the SEQ field of the other table.
This query DOES work:
UPDATE tblWarrClaimLog, tblClaimNumber
SET tblWarrClaimLog.[SEQ]= tblClaimNumber.[ClaimNumber]
So I just need to modify the WHERE conditional
Instead of the 'hard string' I'm trying to use the changing LogNumber string to direct the update to the proper record.
strLogNumber = Me.tbxLogNumber.Value, or
Forms![frmWARR_NewClaims]!tbxLogNumber] instead of WARR-2012-0001
Does not work
? Any ideas ?
Thank-you for your help