Can forms read from different tables (1 Viewer)

[paulmcdonnell]

I'm sure that one form can be used for many different data sources with some code attached to a command button....How do you set the data source using some code so that the form opens and reads from the specified table or query....
Anyone know? would be greatful if you could help
Cheers
Paul..

 

[charityg]

You answered your own question without knowing it!

You would use the forms RecordSource property
Forms!YourForm.RecordSource= "TblName or SQL string"