>>>John, neither the InteractiveChange method nor the ProgrammaticChange method fires when the form refreshes, even if the combo value is changed in the new record.
>>>
>>>To fire InteractiveChange you must be in the combobox, and make a change in the value. To can fire the ProgrammaticChange method, you have to make a call to the combobox, changing it's value.
>>>
>>>What exactly are you trying to accomplish? I'll help figure it out if you'll give me more information.
>>>
>>>Barbara
>>
>>OK Barbara, you've asked for it so here it is.
>>
>>I've designed a form to show real estate agent info (the basic name, address, etc.) The agents table which the form is based upon hold a field called OFFICE_ID, a FK for PK of offices table that holds real estate offices. This relationship links which agent works for which real estate office. I've put up a combo box to show the office name and not the linked key which is only a number. This combobox uses SQL-Select as rowsourcetype and has controlsource of the agents.office_id as the bound column.
>>
>>Now, when I scroll through the agents table, the following sequence of events should happen (I'm assuming here):
>>1. office_id value should change
>>2. combobox value should change since controlsource is set to office_id
>>3. finally, this should cause the ProgrammaticChange event to fire.
>>Shouldn't this happen? However, the ProgrammaticChange event never fires. Do I have to explicitly change the value of the combobox based on changes in my office_id field everytime I move from rec to rec 'in code'?
>>
>>Thanks again for your assistance.
>>
>>John.
>
>John, as I said in my previous message, refreshing the form on a new record does NOT fire the programmatic change event. If you want some code to run when you change the record, then put it in your next/previous buttons or (better) in your Refresh method code.
>
>Are you calling the 'Refresh' method as you scroll through Agents? Either in your Next/Previous buttons or in the InteractiveChange event if you're using a combo box.
>
>If you're using the default Refresh method, then (1) and (2) above will work as expected, but not (3)
>
>Barbara
Just to put an end to this discussion, I already did just what you've suggested, refreshing the info in the forms Refresh method and it works fine. It's just little weird to me. I guess it's just a "feature" that I have to live with.
Thanks again Barbar and all who have responded.
John.
It's "my" world. You're just living in it.