Pass-Through Query as Record Source

  • Thread starter Thread starter Ben Lahoy
  • Start date Start date
B

Ben Lahoy

1. If you are using a pass-through query as the record source for a form,
can you modify the records on that form. I mean the form is a "Sales
Orders" form. So the user should be able to enter, and modify the records.

2. If you can modify the data on the form, what instance or instances can a
table field become un-updateable because the form is using a pass-through
query.


Thanks,

Ben


P.S. I have already posted this at microsoft.public.access.forms newsgroup
also but no answers as yet.
 
The pass-through query is not updatable. So, 1) no 2) all.

That said. You must consider several things. First, if you want to
update the table on the source database, then you should Link the
table (Warning!) or us other means. If you just want to do some data
mining then use the Pass-through query to download the data to your
own tables (Append or MakeTable) and use that table for your forms.

- GL
 
Back
Top