>>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