Sub Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a form with a subform that has worked for some time. I added a new
table and included a field from the new table (through a query) in the form
and subform but now I am not permitted to change any data in the subform -
all filters, edits, additions and deleteions are allowed.

Please advise whast else ot look for.

Thanks
 
Most likely, the Record Source for the subform because non-updateable when
you added the new table. To check, open the RecordSource and see if there
is a New Record line at the bottom (the one with the *). If it is not
there, your recordset is non-updateable. You'll have to correct that before
it will work. I can't tell you how exactly, without knowing the tables and
such.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thank you Roger. I ran the "Subform's" query and there is no "*" record at
the bottom.

The table has a final * record and so does the query for the Main portion of
the form.

What's next?
 
The form is part of our BOL process.

We had set up the ship from address always to be our facility A standard
text field) -now we are making 3rd party shipments from other locations as a
ship from location.

We created a tabel to maintain the name and address of the ship from and
linked it through the query to this form. The data field "Ship From" is in
both a BOL control table and an Inventory detail table which are header
(form) and detail (subform) of this form.

I will look for a different way to do this.
 
Roger:

Success - I deleted the Subform and recreated without the new table.

Generated a new query to include the ship from address information for use
on the BOL report.

Thanks for your help.
 
Back
Top