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

access 97 forms and tables

P: n/a
is it possible to have two tables as field source in a form? for
instance i created a query that concatenates the comments fields from
two tables (see below). i can easily create a subform however, the
comments field needs to be updateable. as i am writing this, i think
it may be impossible.

if any one has any suggestions, it will be welcomed.
thanks!!

SELECT [Exception Tracking].[ET Number], [Exception Tracking].[ET LN
Shortname], Trim([LT Public Information] & " " & [ET Comment Public])
AS Comments, [Loan Tracking].[LT DB Database]
FROM [Loan Tracking] INNER JOIN [Exception Tracking] ON [Loan
Tracking].[LT Loan Shortname] = [Exception Tracking].[ET LN
Shortname];
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You should certainly be able to create a Form/Subform both of which have a
RecordSource of either the tables or updateable queries. I recommend the
latter, just as a matter of course.

Larry Linson
Microsoft Access MVP

"JMCN" <pi******@yahoo.fr> wrote in message
news:27**************************@posting.google.c om...
is it possible to have two tables as field source in a form? for
instance i created a query that concatenates the comments fields from
two tables (see below). i can easily create a subform however, the
comments field needs to be updateable. as i am writing this, i think
it may be impossible.

if any one has any suggestions, it will be welcomed.
thanks!!

SELECT [Exception Tracking].[ET Number], [Exception Tracking].[ET LN
Shortname], Trim([LT Public Information] & " " & [ET Comment Public])
AS Comments, [Loan Tracking].[LT DB Database]
FROM [Loan Tracking] INNER JOIN [Exception Tracking] ON [Loan
Tracking].[LT Loan Shortname] = [Exception Tracking].[ET LN
Shortname];

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.