Subform filter fails

  • Thread starter LongWayFromHome
  • Start date
L

LongWayFromHome

My filter in a called procedure results in a Null for the record, but I can't
see why. The calling procedure is on the main form, SWB, and the called
procedure is in a utility module. The subform, EndwmtSubFrm, should go to
the specified record, but doesn't. EndwID is a string, and it does pass
correctly from the calling procedure.

Would appreciate any advice on where the problem might be.

Public Sub SetEndwmt(EndwID)
With Forms!SWB!EndwmtSubFrm.Form
.Filter = "EnFNo = '" & EndwID & "'"
.FilterOn = True

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top