Quick question about bound fields

[tgbyhn10]

If I have a bound field on a form is it acceptale to change the value of that field in the code or will access throw a wobly?

 

[Carl Foster]

Yes, you can use code to update the value.

 

[tgbyhn10]

Yes, you can use code to update the value.

Thanks. That's what I thought but Access doesn't work when I do it.

If I enter a value in a bound textbox field on the form I can use the navigation bar to move around the table, the values I enter are saved and everything is fine.

If I set a value in the code like this

me!boundfield.text = "22"

When i try to use the navigation button to move to another record, nothing happens but if I press the same navigation button again, Access will then saves the value I set in the code and move to the next / previous record.

I've been stuck on this for about 5 hours now and it's driving me crazy.

Anyone know why this is happening? Please...

 

[Carl Foster]

Try setting the number to the value property instead.

me!boundfield.value = "22"

The text property holds the current value for the control while the value property holds the saved data for bound control. When you change the text property, the info has to be saved to the field which is done when focus is moved.

Hope this helps

 

[tgbyhn10]

Try setting the number to the value property instead.

me!boundfield.value = "22"

The text property holds the current value for the control while the value property holds the saved data for bound control. When you change the text property, the info has to be saved to the field which is done when focus is moved.

Hope this helps

Thanks for the help but it didn't work. Any more ideas, this is driving me crazy. I wish access would let you know what's going on.

 

[missinglinq]

Where in your code do you have this line?

 

[tgbyhn10]

Where in your code do you have this line?

It is in a routine called CalcFields. The CalcFields sub routine get's called by the forms current event and it gets called by the lost focus event of 46 fields on the form. Is that a problem?

I also zero the value in the form before insert event

Thanks

Pete