Subform Requery

[MTSPEER]

Hello,



I have a couple subforms on a form called Errors. And I have a command button on a form named Validate. The subform I want to requery is called Error_Sheet_CB_Subform. I write the code Me.Error_Sheet_CB_Subform.Requery and an error comes up and displays Compile error: Method or data memeber not found. I don't understand why it is doing this.

[pbaldy]

I've seen that work, but you can try

Me.Error_Sheet_CB_Subform.Form.Requery

If you still get an error, you want the name of the subform control there, not the subform itself if they're different.

[MTSPEER]

That doesn't work. But even when I type in Me. then start typing in the name of the subform it doesn't appear. the database doesn't have any of the subforms recognized

[pbaldy]

With the form in design view, click elsewhere on the form and then once on the subform. Looking at the properties, you should be looking at the subform control. You want the name of the control. If you're still stuck, can you post the db here?

[MTSPEER]

I don't know where you are seeing subform control at. I see Source Object and the Name. I cant send you the DB because there's health info on here. I just don't know why it's doing this. I had no problems with the other databases I built doing this

[pbaldy]

What are the source object and name properties?

[MTSPEER]

Whoops sorry i noticed I calld said the wrong name of the subform..it's called Error_Sheet_CVS_Subform. in the Name field it's called Error_Sheet_CVS subform and in the Source Object field it's called Error_Sheet_CVS_Subform. I tried changing the name to Error_Sheet_CVS_Subform and it still didn't work.

[MTSPEER]

When I use it on the same form as the subforms are on it works..But it doesn't work when Im on a different form. Is there any way to make it work from a different form?

[MTSPEER]

Nevermind guys I found it out the code when using from seperate forms

[pbaldy]

Glad you got it sorted.

[MTSPEER]

Now it doesn't work..It worked yesterday and now it doesn't today..For example, the forms I'm using are called Validate and Errors. The subform Error_Sheet_CVS_subform in on the Errors form. I'm requerying it from the Validate form..so the code I used is Forms![Errors]![Error_Sheet_CVS_subform].Form.Requery I even called it from the Errors form and it's named correctly. I have no idea why it isnt working..I made another copy of this database and then it stopped working? idk why

[MTSPEER]

Now I figured out the form has to be open for it requery..does anyone know of a way where it doesn't have to do that?

[pbaldy]

Not sure either. Is the data from the second form saved at the point you requery?

[pbaldy]

Sorry, was typing while you posted. Why would you requery a closed form? It will requery when it opens.

[MTSPEER]

Because I have a button to validate the information on one form and the subform is on another form because there is no room..but I just made it so when the one form opens. it opens the other