Multiple Source Data

[Anthony George]

Hi Everyone

I'm developing a personal memopad program which I will post on this site when it is finished. It's a bit crude at the moment as I have multiple tables linked to multiple forms all accessed from buttons on a switchboard form.

What I would like to do is just have 2 forms and be able to change the source data setting on the table form to the appropriate table when selected on the switchboard form. So instead of having 48 individual forms with each forms source data setting set to its appropriate table, just the one table form with some sort of variable setting to switch it's source.

Hope this makes sense!

Any help would be greatly appreciated

Best Regards

Tony.

 

[Anthony George]

Must be having a senior moment

Sorry

I think I must have had a senior moment using all those forms.

I now have a switchboard that calls like this: -

DoCmd.OpenForm "general", acNormal
Forms![general].RecordSource = Table1

etc.

figured it out around 6am this morning, never mind

Thanks Anyway

Tony