Sub form filtered by listbox

[BorisGomel]

Hello,



I have a sub form that is called QBCHECKS2011 and form which is called InqireByClients .On form there is a list box (lstClients) that filters the sub form via mother child relationship . “ClienstName” is the same filed that list box and sub form have . It works ok , but there is one problem is that the list box always filters the form by one filed which is “ClientName”. I would like to have sub form not to be filtered until Clients filed is selected in the list box. In another world I would like to open the sub form not filtered and only to be filtered when the Clients is being selected in the list box.
Thank for your advice with this matter.

Best Reagrds

[TheSmileyCoder]

You would need to add code to the AfterUpdate Event of the listbox (and if listbox is bound, also to the Current Event of the form)

If Me.ClientName.ItemData.Count<>0 Then
 Me.QBCHECKS2011.Form.FilterOn=False
Else
 Me.QBCHECKS2011.Form.Filter="You fill in your own filter string here, based on whatever your conditions are"
 Me.QBCHECKS2011.Form.FilterOn=True
End If

[TheSmileyCoder]

Sorry, I have no idea what is wrong with the posting engine on this site, as im quite new here. Try to ignore all the stuff about Size and Font that the site has added.....

[BorisGomel]

Hi TheSmileyCoder.

Thank you very mcuh for youe time of helping me .

I typed the code that you have so graciously provided and it doesn’t work.

The VB debugs mistake in the first line of code:”Method or Data not found”
IfMe.ClientName.ItemData.Count

There is not ClientName in drop menu of VB in the code window .There only Listbox lstClients .I put it in there but the “count” after “Item Data” not showing up in the code drop menu .
Really appreciated if you be so kind of to review the code .

Thank so much for your help.