combo box - requery not firing

[moona]

what could be causing the me.combox_name.requery to not fire?

I have created two combo boxes - everything works the first time I open the form.
The first combo box (master) drops down with the list of records
go to the second combo box (child) and I see the "filtered" records based on the value selected in the first combo box.


I select the record I want.

Go back to the first cmb and select a different value for master
back to the child cmb and I see the same old values


I have a me.cmbchild.requery afterupdate event for the cmbmaster.

What's missing?

[moona]

The form I am using in this example is frmMain

Thanks.

[Bob Fitz]

Make sure you have spelt the name of cmbChild correctly .
Check that you have [Event Procedure] as the setting of the After Update event of cmbMaster.
Can you post a copy of the db in Access 2003 mdb format.

[moona]

Thanks Bob...checked out everything as per your suggestions. Posted a 2007 version of the db - zipped. The form you need is frmMain.
I have to get it working on 2007.

appreciate your help.

[Bob Fitz]

Thanks Bob...checked out everything as per your suggestions. Posted a 2007 version of the db - zipped. The form you need is frmMain.
I have to get it working on 2007.

appreciate your help.

I know that you posted a copy of the db in your first post, but I use A2003 which can not open files created in a later version. That is why I asked if you could post a version in A2003 mdb version.

[rpeare]

Put your REFRESH command in the ON EXIT event instead of the AFTER UPDATE event

[moona]

Hi rpeare, tried that...no difference.

[moona]

sorry Bob, wasn't sure if you had posted your response pre-post my upload of the zip file.
Ok, I am attaching it here after "save as"....

[rpeare]

I downloaded your sample database, cut what you had from the afterupdate event, pasted it into the ON EXIT event and it worked properly.

this is the code exactly

Private Sub cmbmaster_AfterUpdate()
End Sub

Private Sub cmbmaster_Exit(Cancel As Integer)
Me.cmbchild.Requery
End Sub

and it correctly requeries the second combo box

[moona]

Nope...no luck at my end...that's the only code I have on the form and it does not work for me.

Option Compare Database
Option Explicit




Private Sub 
cmbmaster_Exit(Cancel As Integer)
Me.cmbchild.Requery
End Sub

...as suggested in one of the threads on this site...looking for updates for 2007. I thought I had applied all of them. But just in case, I missed something.

as expected...no updates for Ms-Access 2007.

Something is missing/corrupted...

I'll try creating a brand new db, form, tables and see where that takes me.
Will keep you posted.

[Missinglinq]

...that's the only code I have on the form and it does not work for me...

To allow Code to run in 2007/2010 you need to declare the Folder as 'Trusted.'

To trust your folder, click:

1. Office Button (top left)
2. Access Options (bottom of dialog)
3. Trust Center (left)
4. Trust Center Settings (button) on far right
5. Trusted Locations (left)
6. Add new location (button)
7. Enter Folder Name
8. Click on Okay

Linq ;0)>

[moona]

I don't believe this....but that's what did it....

In order of things...

I ended creating a brand new from scratch, db, tables, forms etc...and it was working exactly like I wanted it.
I then saved it and closed A2007.
Came back and re-opened it and it was broken.
Scratched my head...

Launched A2003...
created a new db, form, tables etc...
worked fine.
closed everything.
launched A2003
everthing still working...

Refresh my browser...and see your response.

try it and A2007 works....Bless you.

I must have searched and googled and no where did I see this solution posted.

Thanks a lot.

[Missinglinq]

Well, you're not apt to forget it now, are you?

Glad we could help!

Good luck with your project!

Linq ;0)>