Using Tab controls within a form

[crowegreg]

On a form, I have a tab control with 3 pages. How do you create a recordset to be used on only 1 of the pages? I'd like for the user to select a record via a combo box, then display all the fields associated with this record, and give them the ability of editing these fields. Thank you in advance!!

[June7]

These fields are in the form's RecordSource? Then you want to filter the records. You don't select a record in a combobox, you select a value. If the combobox is bound to a field then that value is saved to table. If purpose of combobox is to only select filter criteria then it should not be bound to a field. Check this tutorial for building a custom filter on a form http://www.datapigtechnologies.com/f...tomfilter.html

If the data you want to view are not part of the form's RecordSet, but are dependent child records, then use a subform on one of the tab pages.

[crowegreg]

I'll try what you've recommended. Thanks!