Sub Form

A

aMack

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
 
R

Roger Carlson

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
 
A

Andy Mack

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?
 
A

Andy Mack

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.
 
A

aMack

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.
 
Top