value stick

[LG]

I have a field in a form name QCP_ID. I have used the after update event and
code builder with the following:
Private sub controlname_afterupdate()
me!qcp_id.defaultvalue = chr(34) & me!controlname & chr(34)
end sub

I got it to work for all the other fields like batch_id and platform but for
some reason just for the qcp_id it gives them a bug error. Any suggestions?

 

[John W. Vinson]

I have a field in a form name QCP_ID. I have used the after update event and
code builder with the following:
Private sub controlname_afterupdate()
me!qcp_id.defaultvalue = chr(34) & me!controlname & chr(34)
end sub

I got it to work for all the other fields like batch_id and platform but for
some reason just for the qcp_id it gives them a bug error. Any suggestions?

What's the datatype of qcp_id? And what's the error? If it's an Autonumber you
can't set its value, but should just let it increment automatically.

 

[LG]

It's a text value and the error gives the box of end debug or help

 

[John W. Vinson]

It's a text value and the error gives the box of end debug or help

Is there an error code or message? "box of end debug or help" doesn't convey
any specifics.