I would like to have a form header with buttons on it that I can press
to change the filter criteria for the form. It would contain peoples
names and update the filter when the button is pressed to show only
records with those poples names in a specific Name field.  I
understand how to read the Caption from the button, but how do I apply
that in a filter? I was panning on using at least half a dozen names
across teh top of teh header. Would it be better to use a list box?

How would I do this? Any help would be appreciated.

Regards,

Aaron

If there are not too many options, you can just use buttons. However, I
suggest it's better to use a combo box to save space on the dialog. Either
way, you can filter the recordset use the "Filter" property. The following
sample code assumes a combo box is used:

rs.Filter = "name = '" & DataCombo1.Text & "'"

Note: the apostrophe ' is necessary here.

I'm a Microsoft Employee, and I've been "encouraged" to include the
following information from our lawyers: this posting is provided "As Is"
with no warranties, and confers no rights. That means there is no warranty
of merchantability or fitness for a particular purpose, and no warranty of
non-infringement. See full details on terms of use.