Cant get this to work...

[Joel]

I have done this a hunderd times now at work but for some reason this will
not work at home. I am running Access 2002 at home and at work I use Access
2003.
All I am try to do is this:
On_Form_Close
me.BPID = me!tbBPID

All i get is this error 2448 You cant assign a value to this object.

me.BPID = null and me!tbBPID = 1

both are number fields long int

I dont get why this is not working

Any suggestions?

 

[Ken Snell [MVP]]

Are you running this code step in the Close event procedure for the form?
Too late to set values at that point. You'll need to run the code step in
some event procedure that occurs earlier than the form's closing.

 

[Joel]

That did it, Thanks Ken

Are you running this code step in the Close event procedure for the form?
Too late to set values at that point. You'll need to run the code step in
some event procedure that occurs earlier than the form's closing.