Form RecordSource to Different Database

[ped]

Hi, i want to set Form RecordSource to Different Database, is that possible, how can i do this?

can i open some connection and make/set RecordSource?
Please advice.

Thanks & Regards
Pedie

[ajetrumpet]

I would advise you to stop asking questions that are all related to one issue: education. try to educate yourself about this. my new post in your other thread should help just fine. take care.

[ped]

ajetrumpet, i learn best from suggestions, examples... aDvices etc from people who has been ahead...
Well without knowing what to look for i cannot go and look for it right?
'm new learner...and have learned a lot in these few days..

Thanks again

I would advise you to stop asking questions that are all related to one issue: education. try to educate yourself about this. my new post in your other thread should help just fine. take care.

[June7]

I think the only way to base a form on tables in another database is to establish links to the tables in the other database. Then those linked tables can be a form's record source.

[ped]

I think the only way to base a form on tables in another database is to establish links to the tables in the other database. Then those linked tables can be a form's record source.

Thanks again June7...

There an article in MS official site which address about doing this using code..

Thanks again

[June7]

Can you provide link to article?

[ped]

Can you provide link to article?

Sorry, i didnt add link earlier...here it is

[June7]

Thank you, I am corrected. I have never bound a form like that, creating table links is just so convenient. However, that is essentially the same method I used trying to create connection for this exercise. I am baffled why it would not work on my home computer. Did not try here at work.

[ped]

Thanks to you June7