Duplicating tabbed form and change record source

[Snoozie kitten]

I have a navigation form that has a tabbed form on one of its tabs. The tabbed form has a 'current client' query record source and allows one to choose from a list of current clients and when a client is selected - details relating to client are displayed on various tabs on tabbed form.

I want to duplicate tabbed form and change record source to a query selecting 'exited clients' so I can see same information but for exited clients.

I have created a new tab on navigation form for my new exited clients tabbed form and changed record source by creating a new exited client query but when I change record source on exited client tabbed form it automatically changes record source of current client tabbed form to the exited client query and visa versa.

Any thoughts?

 

[Uncle Gizmo]

>>>I have a navigation form that has a tabbed form on one of its tabs<<<

The form on the tab, is it within a subform/subreport control?

 

[vbaInet]

How did you change the "Record Source"? It's a Navigation Form so what you should be changing is it Target Name.

 

[Snoozie kitten]

Hi all. Sorry for the delay in response ...too busy until now. After spending more time nutting it out today I found my problem...My bad..silly mistake. Thanks for responding tho . Tks Access Blaster ....i like my sleep .