Changing the RecordSource of a copied subform

[djdeuph]

Hi there,

I copied a subform and renamed it as I needed to store data entered from different phases of the project into separate tables. I changed the recordsource of the "new" form to my 2nd table. However, when I do that, Access also automatically changes the recordsource of the original "source" form. When I switch one recordsource back to the original table, it changes both forms. Is there a way to break this link?

Thanks!

Derek Danilson

 

[TheAceMan1]

How are ya djdeuph . . .

Did you paste into the forms window or another form?

See Ya! . . . . . .

Be sure to see thread181-473997

 

[boblarson]

Turn off Autoname Correct.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com