Filtering a subform in datasheet view 1

[Johnnycat1]

I am trying to filter the data in a subform based on a combo box "Combo16" in the main form. The code that I am using is:

DoCmd.ApplyFilter , "Forms!FrmBallastTracking!FrmBallastTrackingSubform![Project Name] = Forms!FrmBallastTracking![Combo16]"

The error that I get is that the form is not based on a table or query.

What am I doing wrong? Is there a simple way to filter a subform when the main form is not based on a query?

 

[PHV]

What about something like this ?

With Forms!FrmBallastTracking!FrmBallastTrackingSubform.Form
  .Filter = "[Project Name]='" & Forms!FrmBallastTracking![Combo16] & "'"
  .FilterOn = True
End With

If [Project Name] is defined as numeric in the subform's underlaying table/query then get rid of the single quotes.

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

 

[Johnnycat1]

PH That worked perfectly! Thanks for the help.