Access can't find form to requery

mapat

Registered User.
Local time
Yesterday, 22:55
Joined
Feb 2, 2007
Messages
176
I have a main form "MainA", and 2 sub forms "SubB" and "SubC" on it. From the Current Event of "SubC", I want to requery or refresh "SubB", and this is when Access tells me: "can't find the form SubB referred to in a ..." This is my code on the On Current event of SubC:

Private Sub Form_Current()
[Forms]![SubB].Refresh
[Forms]![SubB].Requery
End Sub

Also, is there anyway that I can select an entire record on a form seen on data sheet view and make that record to be entirely highlighted with a specific color as I select it? If so, how would I do that?

Thanks everyone
 

Users who are viewing this thread

Back
Top Bottom