[dba-SQLServer]Bound forms filtered on a control on the form

Selina Iddon selina at easydatabases.com.au
Tue Feb 25 16:31:26 CST 2003


Hi John
I may be reading the question wrong, but would this help?

Sub MyComboControl_AfterUpdate()
Me.Filter = "FieldName = " & Me.MyComboControl
Me.FilterOn = true
End Sub

Cheers
Selina


----------------------------------------------------------------------------
---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy Access
Databases
----- Original Message -----
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD-SQLServer" <dba-sqlserver at databaseadvisors.com>
Sent: Wednesday, February 26, 2003 7:53 AM
Subject: [dba-SQLServer]Bound forms filtered on a control on the form


> I have been following the thread on the report thing.  The discussion has
> focused (the ones I have read) on using XP, where there are actually
> properties to do this.  How do I do this in A2K?
>
> I have a form.  I want to select a record in a combo box.  Having selected
> that record, I want to run an sproc, passing a parameter to filter the
data
> returned to only return the record selected in the combo box.
>
> How do I do that in A2K?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.
> Try it free!  http://www.eMailBoss.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>





More information about the dba-SQLServer mailing list