RecordSource of Form

  • Thread starter Thread starter John
  • Start date Start date
J

John

The dilemma I am facing is that I have a set of data from
a SQL-Pass Through that is non-updatable. I also have
another set of data that is updatable. When I join them
together, it the form itself is non-updatable. Is there a
way to make the recordsource updatable (I just do not know
how to make the SQL-pass through query updateable)

Thanks,
John
 
John,

If you don't need to update the data in the passthrough query, then turn it
into (I believe this is possible) a make table (to create a new table each
time) or append query (preceeded by a delete query to remove records) into
an existing table. That data is updatable and should solve the problem.
You can put the action query(s) in the Open or Load event of the form.

God Bless,

Mark A. Sam
 
Back
Top