combo box in tab does not change in value

[iam via AccessMonster.com]

Good day to all of you...

I have a problem on my form. By the way the database about meetings &
discussed topics

I have a form with 2 tabs...
The first tab has 2 subform. The first subform is about the attendees while
the second subform is about the agenda for the meeting.
The 2nd tab has only 1 sub form but this form is connected to the 1st tab 2nd
subform which is the agenda. I have a combo box that selects the agenda
encoded in the 1st tab.

My problem is that i have filtered what data should be displayed, example
minutes record #1 has 3 agenda the combo box in the 2nd tab will display all
this 3 records, but upon changing the minutes record #1 to #2 which has 4
records the combo box is not update. It stays with the value of the first
selection which is in my example #1.

I have used this select stament in the rowsource

SELECT TAgenda.AgendaID, TAgenda.MinID, TAgenda.Topic, TAgenda.EmpID, TAgenda.
Type FROM TAgenda WHERE ((TAgenda.MinID)=Forms!FMinutes!MinID);

Why is that the combo box does not change after i have changed the record of
the Main form.

What should i do??

Please help.... thank you so much in advance........

 

[Guest]

Hi - sounds like you just need to refresh the form after changing. Use the
After Update event and put in some code or just a macro that updates the
Field. Yours - Dika

 

[iam via AccessMonster.com]

Hello... thank you for your quick reply...

can i ask you how can i do it?? I'm a bit confused on how it should be done..
...

Thank you so much in advance....

Hi - sounds like you just need to refresh the form after changing. Use the
After Update event and put in some code or just a macro that updates the
Field. Yours - Dika

Good day to all of you...

[quoted text clipped - 25 lines]

Please help.... thank you so much in advance........