access 97 forms and tables

[JMCN]

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];

[Larry Linson]

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];