value stick

  • Thread starter Thread starter LG
  • Start date Start date
L

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?
 
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?
Click to expand...

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.
 
It's a text value and the error gives the box of end debug or help
Click to expand...

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