Data Entry in Form

  • Thread starter Thread starter Amy Schmid
  • Start date Start date
A

Amy Schmid

Good afternoon,

I am having a hard time with my form. I need my form to allow me to input
data by year and hold that data. I have my queries set up and they are
running correctly. I just cannot get the form to allow for data entry. I
click on an open box and it just beeps at me.

Here is the SQL view of my query that drives my form:
SELECT dbo_ajs_Ag_FS_Section.FSSection, dbo_ajs_Ag_FS_Data.Cltnum,
dbo_ajs_Ag_FS_Data.FSYear, dbo_ajs_Ag_FS_Detail.FSDetailName,
dbo_ajs_Ag_FS_Data.FSAmount
FROM dbo_Clients RIGHT JOIN ((dbo_ajs_Ag_FS_Section RIGHT JOIN
dbo_ajs_Ag_FS_Detail ON dbo_ajs_Ag_FS_Section.FSSectionID =
dbo_ajs_Ag_FS_Detail.FSSection) LEFT JOIN dbo_ajs_Ag_FS_Data ON
dbo_ajs_Ag_FS_Detail.FSDetailID = dbo_ajs_Ag_FS_Data.FSDetailID) ON
dbo_Clients.Cltnum = dbo_ajs_Ag_FS_Data.Cltnum
GROUP BY dbo_ajs_Ag_FS_Section.FSSection, dbo_ajs_Ag_FS_Data.Cltnum,
dbo_ajs_Ag_FS_Data.FSYear, dbo_ajs_Ag_FS_Detail.FSDetailName,
dbo_ajs_Ag_FS_Data.FSAmount, dbo_ajs_Ag_FS_Section.FSSectionID,
dbo_ajs_Ag_FS_Data.FSDetailID
HAVING (((dbo_ajs_Ag_FS_Data.Cltnum)=[Enter Client Number]) AND
((dbo_ajs_Ag_FS_Data.FSYear)=[Enter Year]))
ORDER BY dbo_ajs_Ag_FS_Data.FSYear DESC , dbo_ajs_Ag_FS_Section.FSSectionID,
dbo_ajs_Ag_FS_Data.FSDetailID;

If you need more information, please let me know. I am not sure what all to
give in order for someone to be able to help me. I am able to maintain
existing forms, queries and tables but setting up a new one is getting to be
quite the headache. :(

Thanks,
Amy
 
You are using a totals query - grouping. Access would not know which records
that the data entry is suppose to be recorded. So no edits.
 
Back
Top