Subform not allowing update

[Devin]

Hi,
I'm sure there is a simple answer to this, but for some reason my
subform isn't allowing me to add records and I'm not sure why. I've
gone through this set up a few times and I have previously been able
to add records. Is there a common pitfall that I've got caught in?
There is a link to an image just in case that helps clarify what I
mean

Thanks!




http://www.mediafire.com/imageview.php?quickkey=xwgktdnux2d&thumb=5

 

[Rick Brandt]

Hi,
I'm sure there is a simple answer to this, but for some reason my
subform isn't allowing me to add records and I'm not sure why. I've
gone through this set up a few times and I have previously been able to
add records. Is there a common pitfall that I've got caught in? There
is a link to an image just in case that helps clarify what I mean

Most common is having a RecordSource query for the form that does not
allow updates. Many queries by their structure produce read-only output.

 

[Devin]

Any clues as to how I would adjust this or work around it?

 

[Rick Brandt]

Any clues as to how I would adjust this or work around it?

Some non-updateable queries can be adjusted so that they are. Post the
SQL of your query and you might get some suggestions.

Hints:
Queries using DISTINCT are never updateable.
Queries using GroupBy are never updateable.
UNION queries are never updateable.
Passthrough queries are never updateable.

Multi-table queries can go either way. The more tables, the less likely
you can get an editable result.

 

[Devin]

Some non-updateable queries can be adjusted so that they are.  Post the
SQL of your query and you might get some suggestions.  

Hints:
Queries using DISTINCT are never updateable.
Queries using GroupBy are never updateable.
UNION queries are never updateable.
Passthrough queries are never updateable.

Multi-table queries can go either way.  The more tables, the less likely
you can get an editable result.

SHEET_MUSIC is the master table.
sID, etc, etc.

GENRE_LINK:
sID, gID

GENRE:
gID, genre


Genre_Link Query:
SELECT GENRE_LINK.sID, GENRE_LINK.gID
FROM SHEET_MUSIC INNER JOIN GENRE_LINK ON SHEET_MUSIC.sID =
GENRE_LINK.sID;

genre_genreLink Query:
SELECT [GENRE_LINK Query].gID, GENRES.Genre, [GENRE_LINK Query].sID
FROM [GENRE_LINK Query] INNER JOIN GENRES ON ([GENRE_LINK Query].gID =
GENRES.gID) AND ([GENRE_LINK Query].gID = GENRES.gID);



The latter is the query used by the subform. I hope this information
is useful in assisting me


D.

 

[Rick Brandt]

SHEET_MUSIC is the master table.
sID, etc, etc.

GENRE_LINK:
sID, gID

GENRE:
gID, genre


Genre_Link Query:
SELECT GENRE_LINK.sID, GENRE_LINK.gID FROM SHEET_MUSIC INNER JOIN
GENRE_LINK ON SHEET_MUSIC.sID = GENRE_LINK.sID;

genre_genreLink Query:
SELECT [GENRE_LINK Query].gID, GENRES.Genre, [GENRE_LINK Query].sID FROM
[GENRE_LINK Query] INNER JOIN GENRES ON ([GENRE_LINK Query].gID =
GENRES.gID) AND ([GENRE_LINK Query].gID = GENRES.gID);



The latter is the query used by the subform. I hope this information is
useful in assisting me

A multi-input query with one of those inputs itself being another multi-
input query is almost guaranteed to not allow edits. Normally in a form/
subform setup each form is bound to exactly one table or to a query that
uses exactly one table. The MasterLink and ChildLink properties then
create the result of seeing only the related records in the subform.