Can't Add New Record

[mewins]

I have a database that was working fine but now you can't add new records to
it. I have a main form that shows information regarding awards and is linked
by the funder's name to tblFundInfo. I run the form off of a query (code
below):

SELECT tblMainAwardInfo.AwardName, tblMainAwardInfo.FundName,
tblMainAwardInfo.TypeAward, tblMainAwardInfo.Notes,
tblMainAwardInfo.AwardLocat, tblMainAwardInfo.Dept, tblMainAwardInfo.AwardID,
tblFundInfo.FundType
FROM tblFundInfo INNER JOIN tblMainAwardInfo ON tblFundInfo.FundName =
tblMainAwardInfo.FundName
ORDER BY tblMainAwardInfo.AwardName;


The query contains everything in tblMainAwardInfo and just the funder's name
from tblFundInfo. Everything was working fine last week and now for no
apparent reason new records can't be added in the form. New records can be
added directly into the table, but it's annoying. The form is set to allow
additions/edits/etc, but if/when I run the query behind it, it's no longer
updatable. If I recreate the query, I can't update that either. Both of the
tables seem ok, and nothing has changed as far as I know (both still have ID
numbers that autonumber and are still marked as the primary keys).

Any ideas on how to fix this? Thanks!

 

[Klatuu]

It is possible you have developed a corruption problem.
Hopefully, you have a recent backup. If so, delete the form, do a compact
and repair, and import the form from your backup.

That may solve it. If not, the procedure is a bit more involved.

 

[mewins]

Compacting and repairing doesn't have any effects. I've tried rebuilding the
form and the actual tables, to no avail. I'm beginning to wonder if it's how
the tables are structured? Though the tables were fine up until about a week
ago and records were added without any problem. Any ideas on how to solve
this?

 

[mewins]

I've tried compacting and repairing and that doesn't do anything. I've also
rebuilt the forms and tables, to no avail. Any ideas on what could be
causing this? Again, I can still add new records in the database, but not in
the form (which runs off a query). Is my query somehow wrong? I've rebuilt
it but that doesn't seem to help anything. Any ideas on how to fix this?
Thanks.

 

[mewins]

Sorry for the prior repeat posts; thought my first post didn't go through. I
have discovered that the trouble seems to be with the query that's running my
form and the links between tblMainAwardInfo and tblFundInfo. If there are no
links between them (linking FundName which would be the same in both tables),
then I can add records. If I link the two by FundName, then I can't add
records (even if I do the different kinds of joins between the two tables).
Any ideas? I'd like to be able to keep the two linked via FundName so I can
get some other information from tblFundInfo if at all possible. Thanks.

 

[Klatuu]

Without knowing how your tables are structured, I can't be sure, but it may
be that you have created an uneditable recordset. That can happen several
ways, but in your case I am guessing you are trying to do an update or append
in a many to one relationship. Sometimes it can't figure out which record to
process.

 

[mewins]

I think that may be what's going on. If i just set up a query with the two
tables and look at what pops up, it's uneditable. How can I set it so that I
can see the information I want without making it not uneditable?
Specifically, I'd like to see from tblMainAwardInfo:

AwardName
FundName

and from tblFundInfo
FunderType

I have these two tables joined via FundName (the field exists in both
tables), but no matter how I do the join, it doesn't seem to work. Ideas?
Thanks!

 

[Klatuu]

You really can't do that with one query. You will have to have one to view
the data and another that only includes the table you want to update.

 

[mewins]

Ok, I'll just take out the one field that required I have the form from a
query rather than just the table. Thanks.