Variables in TransferDatabase Action

[highbulp]

Hey guys,

I would like to be able to link a table from another database and then run some queries and stuff on it from a macro. I know that I will need to use the TransferDatabase action (with the Link type). The only issue is that I would like to be able to specify the to the database to link to somewhere other than in the macro, such as in a field on a Form. Is this possible? How do I go about doing it (adding [Forms!FormName!FieldName!] didn't work).

Thank you for any help.

 

[gemma-the-husky]

not quite right

you just need to connect to it

file, get external data, link tables

then for the most part, you can use the table like any other

 

[highbulp]

not quite right

you just need to connect to it

file, get external data, link tables

then for the most part, you can use the table like any other

I know, I was wondering if there was a way to automate that instead of needing to go through the menus. But it's not a problem, I decided that using the menus wasn't that complicated for my users so just included that in the procedure.