Why Form Is Both Updatable and Not So

[Earl C Phillips]

I have a form "frmAllSchedule" which displays volunteer scheduling records in datasheet format. The query fetching the data has a parameter to fetch the date from a secondary form ([Forms].[frmProjForm].[txtDate]) and the code from the main form ([Forms].[frmMain].[cboActivity]). If "frmAllSchedule" is launched directly from the Database Window, the user can enter the date and code into prompts. Each line of "frmAllSchedule" is then updatable. If, however, form frmMain is launched first, then "frmProjForm" is then launched, and then a specific date from within frmProjForm is clicked on , the resulting "frmAllSchedule" is not updatable.

Why does the same form using the same query to select data allow updating data when launched directly from the Database Window and prevent updating data when launched from a secondary form within the application?

Any help is appreciated. It will speed up scheduling volunteers at the food
bank when they call in to help.

Earl C Phillips
Volunteer Programmer, Ex-mainframer Learning
Access To Make Feeding The Hungry Efficient
Harvesters Community Food Network
Kansas City, MO

 

[lcook1974]

More of a visual type guy here...could you post a sample DB?