Subform refresh??

[xaysana]

Refresh Combolist in TabControl

Dear there please help,

I have problem with my Fixed Assets Database.

I have a main form called Fixed Assets which involves 2 Tab Controls. One named Page1 and other named Page2. In Page2 Tab Control, there are 2 combo boxes one named Projects and BudgetCode for other.

Problem is that everytine when I go back to the old records for data validation, when I click at BudgetCode pulldown menu, it does not display irrelevant informations which I dislike them to appear until I press F9 (refresh Tab control?).

Please find the attachment, please edit it if nescessary then send it back to me.

Please if anyone could help, I would really be appriciated

Thank you in advance

Best.

 

[modest]

Are you sure your attached the correct database?

I am not seeing any Fixed Assets forms and no form has two combo boxes.

 

[modest]

<To readers: xaysana updated the attached database>

I have renamed your combo boxes and added two different events with conditional statements, which I assume is what you're looking for (a updated combo list when flipping through the different records).

I commented out whether or not you would like to clear the combo value when the list is different. You can uncomment if you like.

 

[xaysana]

Yes, this is what i am after.

I really appriciate for your help

Thank you so much

With best regards,