Database attached:
Financial Officers Database.accdb.zip
Database attached:
Financial Officers Database.accdb.zip
I don't see that you have attempted either of the options suggested in post 10. I forgot I had downloaded your database from post 6. You have changed data structure to separate Add and Remove records into two tables. I recommend only one table.
tbl_FASTDates
ID
ReportDate
RunType (Add, Remove, Both)
StartDate
EndDate
A record entry/edit is committed to table when move to another record or close form or run code.
Set form FAST Access Report recordsource to: SELECT * FROM tbl_FASTDates ORDER BY ID DESC;
With option 1:
Locked textboxes bound to the fields to display latest record info.
Two UNBOUND textboxes to input start and end dates for a new run.
Code behind buttons saves record to table. Example:
CurrentDb.Execute "INSERT INTO tblFASTDates (RunType, ReportDate, StartDate, EndDate) VALUES('Add', #" & Date() & "#, #" & Me.StartDate & "#, #" & Me.EndDate & "#)"
If you want to can then requery the form so the new record now displays.
With option 2:
Open form to a new record row.
Two textboxes with DLookup() expressions to display the last start and end dates.
User inputs start and end dates into bound controls, DefaultValue property can set the value for ReportDate field.
Code in button Click event will populate RunType field with appropriate value, example:
Me!RunType = "Add"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7, thank you for all of the help, I was able to create the database.