Split Form

[bmac]

Is it possible to create a split form where the split part of the form is filtered showing only those fields of a member defined by a combobox control in the parent part of the form?

Bill

 

[John Big Booty]

Have a look at setting up a Form/SubForm.

 

[bmac]

Have a look at setting up a Form/SubForm.

Thanks - but a split form is not a subform - or is it?

I have searched all over and cannot find any reference to filtering a Access 2007 Split form.

Bill

 

[John Big Booty]

Depending on your data structure, You might be able to do something with a continuous form and put your combo in the forms header. Is that what you mean?

 

[boblarson]

A split form (Access 2007) is one which shows a datasheet for all of the records and basically a single record view for the selected one. So, yes you can filter the form for what you want. What are you currently using for the form's record source?