View Single Post
  #3  
Old April 26th, 2004, 07:20 PM
dandgard
external usenet poster
 
Posts: n/a
Default adding records to linked tables


You must make sure that the query you created is updateable. Often when
creating links between tables abiguities arise and access cannot tell
what record in which table to update, at that point it just doesn't
allow any updates or additions.

If the query will allow updates then the form with the query as a data
source should allow updates.

If the query allows updates check the form to make sure the form allows
additions.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/