It shouldn't be too hard to add an "Add New Pilot" button to the Form that allows them to, well, add new Pilots to the database. If they end up having to add too many Pilots (they add so many it gets hard to find any particular one), we can make changes then. That shouldn't really be an issue though.
As for the Forecast, what you might want to do is make a whole new set of "Forecast" Tables with their own Form. Then you can do whatever you want to those Tables without having to worry about anything getting messed up in the "real" Event Log.
That On Open error is coming from a Startup Macro that's trying to run. I wasn't able to open the Macro earlier so it's probably safe to just delete. We can do that once I take a look at your revised db.