By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Setting a front-end RecordSource as a back-end table

P: 11
Hi,

I was wondering if there is a way to set the RecordSource property of a form in my front-end as a table in my back-end. Another additional hurdle is that the table name is a variable, because it depends on a reference number selected. There are no table links between these particular tables between the front-end and back-end because I create them through the code as I go.

I have heard of using 'remote queries' but to use this would mean the data cannot be altered - wouldn't it?

Thanks in advance for your help
Nov 30 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

I was wondering if there is a way to set the RecordSource property of a form in my front-end as a table in my back-end. Another additional hurdle is that the table name is a variable, because it depends on a reference number selected. There are no table links between these particular tables between the front-end and back-end because I create them through the code as I go.

I have heard of using 'remote queries' but to use this would mean the data cannot be altered - wouldn't it?

Thanks in advance for your help
You don't say what your backend is built in Access, SQL or other.

However, assuming its Access. The only way to do what you want is after building the table using code you need to use the

Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferDatabase acLink, ....
to link the table to the frontend and then use code to set it as the record source of the form. This code will need to be in the On load event of the form.
Nov 30 '06 #2

P: 11
Thanks Mary

Chanelle
Nov 30 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks Mary

Chanelle
You're Welcome.
Nov 30 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.