Using a combo box to change records

[Mickster]

Hi all,

I was wondering how would we change the forms row source everytime a new new item is selected in a combo box.

For instance here is a table:

ID Name Status
1 Joe Active
2 Fred Inactive
3 Sam Inactive

So if the names were to be displayed in a combo box and the status is represented by a option group. How could I make the combo box change the record instead of having to use the record selector

Any help would be appreciated

thanks

 

[pyrohavoc]

Add an unbound combo to your form header. The wizard will walk you through the process. Be sure to choose the option to "find a record on the current form".

do you know if there is a way to modify that?

what i'm trying to do is similar but my form only shows one record at a time ... i want to filter available records by casemanagers.casemanager via a combo box in the header