Changing a forms source data. 1

[ninash]

Hi All

Is there a way of changing a forms source data collection?

When a form is designed you link it to a table or query, what I want to do select a different query depending on which button the user chooses.

I know it might sound odd but it should save me alot of replication in form generation.

Tony

 

[KenReay]

Hi

You mean like:

Me.Recordsource = "SELECT * FROM Table1;"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ninash]

Thanks Ken

Works a treat, I don't know why I didn't see it.

Have a star

Tony