combo boxes refresh

[anissw]

Hi- I have 3 combo boxes for selecting clients, start and end date ranges. I created an indicator to flag true if I have used a start and end date. However, i need to include the client combo box as well. The process should be select client, select start date, select end dates. Restriction should only display for client where the date ranges are false. I am having a hard time getting the refresh setup (I know it's in the event for after updates, but am unfamiliar with the coding. Attached is a screen shot of my setup. I have restriction in the query for start and end dates to display where indicator is False. Any suggestions as how to setup refresh in VBA?

Thanks-

Anissa

 

[thechazm]

I understand what you are saying but without seeing some code that you already have or posting an example db then I cannot help. Please provide the additional info as much as you can.

 

[anissw]

Hi thechazm-

Thanks for replying. After a good night's sleep, it had come to me to use the requery option in VBA. I have created test database of my current database and have posted for your viewing of what I finally did and it worked perfectly. Please review and any additional suggestions you can give is appreciated as well.