Requery VBA Can't Find Form (1 Viewer)

[Madmart1gan]

I have a form that users use to input data into a table. I then have another form that shows the last saved/entered record. My intent is that after the data entry form is closed, VBA will trigger to refresh the last saved record form (named fLastSavedRecord). My VBA is:

 Private Sub SavedRec()
Forms!fLastSavedRecord.Requery
End Sub

When I run this code I get an error that says:

Run-time error '2450':
Microsoft Access cannot find the referenced form 'fLastSavedRecord'.

I have been trying variations for two days and cannot figure why it can't "see" my form. Just to test, if I go to create a Macro and use the 'OpenForm' command, the fLastSavedRecord form is available in the drop-down. I don't get it.

 

[Madmart1gan]

Solved the problem thanks to this page:

http://access.mvps.org/access/forms/frm0031.htm

I needed to reference my main form in the code. Here is the code that ended up working for me:

Private Sub SavedRec()
Forms!fMain!fLastSavedRecord.Requery
End Sub