Requery Module that can't find form

[mlunter]

Hello,

I have a form (called "A"), with another subform (called "B") inside of it. There are three listboxes in form A that use queries to lookup values. Form A is unbound. Form B, which is bound to a query, is supposed to take values from form A.

I have the default values for the fields on Form A set. When I first open the form, everything works as it should. Form A and Form B popup with all the correct information. I want to be able to requery Form B with every listbox update from form A.

So I wrote a module on the AfterUpdate property of one of the listboxes that is as follows:


Private Sub B_AfterUpdate()
Forms!b.Requery
End Sub



Microsoft Access keeps telling me it can't find Form b referred to in the macro or visual basic code. When I changed the code to requery form a, things work fine. I tried changing the name of the form and everything. Nothing is working. Any suggestions would be greatly appreciated.

Thank you,
MSL

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886