467,086 Members | 1,195 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,086 developers. It's quick & easy.

Yet another Query Linking Question

I'm sorry to populate the server with yet another question about
linking multiple tables and queries, howerver I have not been able to
find the right criteria.

My problem.

I am trying to either link 3 tables together in a select query, and
maintain the editablity that I get when linking two tables and creating
a form. I know there is a way to link 3 tables through multiple queries
however I have yet to be able to get it to work.

More specifically.

I have a form that only requires two tables to come together through a
query, this way the form or records are editable. My report for this
form has one function bound (unbound with a function in the control
source) text box that requires I pull information from a table outside
of my two table query form. I am a beginner and have no clue as how to
write code. So is there a way to reference information stored on a form
that is closed at the time it is needed to be accessed, through the
control source or a macro? Please let me know if you need for
information. Thanks again everyone.

Nov 13 '05 #1
  • viewed: 1680
Share:
1 Reply
I don't know all of the specifics, however, if you need to pull a value from
a table outside the record source query, one alternative would be to use the
DLookup function. The third parameter of this function allows you to
specify the criteria for the value, which you can tie to one or more fields
in your record source query. Depending on the exact circumstances, this
would have the same effect as joining the table with the other two in the
record source query. The following link gives more information on the
DLookup function.

http://msdn.microsoft.com/library/de...HV05187182.asp

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
<hm*****@hartford.edu> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I'm sorry to populate the server with yet another question about
linking multiple tables and queries, howerver I have not been able to
find the right criteria.

My problem.

I am trying to either link 3 tables together in a select query, and
maintain the editablity that I get when linking two tables and creating
a form. I know there is a way to link 3 tables through multiple queries
however I have yet to be able to get it to work.

More specifically.

I have a form that only requires two tables to come together through a
query, this way the form or records are editable. My report for this
form has one function bound (unbound with a function in the control
source) text box that requires I pull information from a table outside
of my two table query form. I am a beginner and have no clue as how to
write code. So is there a way to reference information stored on a form
that is closed at the time it is needed to be accessed, through the
control source or a macro? Please let me know if you need for
information. Thanks again everyone.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Joe Makowiec | last post: by
6 posts views Thread by Rudy Ray Moore | last post: by
6 posts views Thread by Darren | last post: by
4 posts views Thread by franc sutherland | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.