can't assign a new value to a form field

[markjkubicki]

I've got a condition where, when the user has made a duplicate entry in the primary key field of a record entry, i don't want to junk the whole record as being invalid, but flag it as a duplicate field, preserving the remainder of the record entry, and allow the user an opportunity to review the original and then decide how to handle the duplicate value....

so i wrote this snippet... but i am not able to (and it may be an obvious problem to an experienced programmer -which i am not) re-assign a value to that field (me.type)

If DCount("[type]", "tbeFixtureTypeDetails", "[type]= '" & Me.Type & "'") > 0 Then
vmsgtxt = "This fixture type is already being used; please try again"
vmsgtitle = "DUPLICATE FIXTURE TYPE"
Response = MsgBox(vmsgtxt, vbCritical + vbRetryCancel, vmsgtitle)
vType = Me.txtType & "-DUP!"
Cancel = True
' --- this next line in the problem
Me.txtType = vType
' ---
End If

any thoughts would be greatly appreciated in advance


mark

[ssanfu]

What is the error message?
Is vType declared as a string?

BTW, "Type" is a reserved word in Access and shouldn't be used for object names. In addition, it is not very descriptive.
See http://allenbrowne.com/AppIssueBadWord.html

[markjkubicki]

vType IS declared as a string

(I know about the "string" reserved thing... unfortunately, I inherited it; and within the project... it's everywhere -ugh)

but the "type" is actually not giving me a problem (the DCount works just fine);
the problem is assigning a value to the control txtType... and maybe that's the problem (?) Do I need to assign the value to the field, and not the control (?) ...sounds wrong to me; but hey, learn samething new every day and just maybe ...

[ssanfu]

but the "type" is actually not giving me a problem (the DCount works just fine);

OK, but at somepoint, it will give you problems. Just be ready for them.

Without being able to execute the code, it is hard to tell why you can't assign the value to the control.
Set a break point at the line

vType = Me.txtType & "-DUP!"

then single step through the code, looking at the variables. (debug window)
Check the value of vType, then step down two lines and look at the value for Me.txtType.

[Missinglinq]

You really need to answer ssanfu's question "What is the error message?"

Also, where do you have this code placed? I suspect that this may be the problem; you cannot, for instance, assign a Value to the txtType Control, with code in the txtType_BeforeUpdate event. Could this be the error message you're receiving?

"The macro or function set to the BeforeUpdate event or Validation rule Property for this Field is preventing Microsoft Office Access from saving the data in the field."

I also need to emphasize ssanfu's warning about using Reserved Words as names; sooner or later this is going to bite you in the rump, and this kind of thing can be very difficult to debug!

Linq ;0)>