Hello to all,

I have just joined wrox forum. It’s a great effort by all team.
Now I come to my point. Recently I have worked with Access 2003 (mdb) version. Due to some reasons I have to transform myself in Access 2007. I don’t have high database expertise but worked well in 2003 format. When I started working in access 2007, it threatened me much. Anyway I tried to settled the things. One thing which has made me sick is requerying a bounded combobox placed on a sub form. I am trying desperately but outcome is nothing. Can any body explain how to use requery method for combox in subform and in which event. Looking for quick response please. Thanks in advance....

Need a some more details on exactly what you are trying to do.

When do you need to requery the combo box control?

Is the sub form in single, datasheet, or continuous view?

Are you trying to requery the combo box in the sub form from the parent form?

try:

Me.[Sub Form Contyrol name].form![Combo box control name].Requery

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Ok. I have Main bounded Form named "frmOrganizations". This form contains many bounded controls like textboxes, comboboxes, subforms. One of the control that frmOrganizations contained is "subformDFO" subform which contains a bounded combobox "cboDFO". In order to add/update the values of cboDFO I have another bounded form named "frmAdd" which contains a bounded textbox "txtAddDFO". Now when I add new value in txtAddDFO it must be updated in cboDFO.
I have tried your code but results are not there.

I can also mail (if you could provide me email address) you database as I have to resolve this issue in hurry. It was not tough in Access 2003 but I am not getting it in Access 2007...

AFAIK, you should be able to do it the same in 2007 as you would in 2003. My forms that do this in 2003 still work the same way in 2007.

Can you post the VBA code you are using now.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

I have done it. Thank you very much for your support and guideline. Actually it was just a single option that has made my life a hell. It was VBA Macro option which by default is not enabled. When I enabled that option all the vba codes started working correctly. I request you please guide other non-expert like me about this option which creates many many difficulties during code execution. Again thank you very much...

Ah .. the trusted locations and enabling the VBA code issue.

With Access 2007 you need to be sure and create a trusted location of the folder where you place your database.

You might also want to set the Macro Security Level to Low for each user.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thank you it helped alot

This article I wrote may also help:

Trust Center in Access 2007 and 2010 Trusted Locations

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Great... I am going to creat account in HiTech Coaching.com