Filter Command Button 1

[jfussell]

I need some help creating a command button for a form that can: 1) opens another form, 2) filters through the open form and only show the records that is linked to a "client ID" field in the initial form.
Thanks a ton!!

 

[Maquis]

You need something similar to the following code. Put this in the click event of your command button.

Dim LinkFilter as string
Dim FormName as string

LinkFilter = ""
if not(isnull(me!clientid)) then
LinkFilter = "[Clientid] = " & Me!clientID
end if

FormName = <your form>
DoCmd.OpenForm FormName, acNormal, , LinkFilter

 

[jfussell]

Great, thanks for your help on this!!