change value After Update

[alex]

Hello,

I have 3 unbound listboxes on a form that also contains a subform.

I am trying to change the value in one of the listboxes after the
subform updates. I can't seem to do it, however.

For example:

lstBox1 value is 'A'
Once the subform is updated/saved, I want the value of lstBox1 to
become 'B' . (what I'm trying to do is always have listBox1 default
to 'B' after a record is entered, even if the user selects 'A').

I've tried setting the focus back to the main form first, then
changing the value...no luck.

any thought?
alex

 

[schasteen]

It would be helpfull if you would post your code so we could take a look at
it.

I would suggest in the subforms after update event
Forms!MainFormName!lstBox1 = "A"

You may want to add some code to ensure that the is still data and that the
user didn't delete the only record.