I'm struggling getting a grid to save data. It will only save changes for the row the cursor is on.
I created a form using the "Classic" category in the New Form Wizard. I selected "Build From Scratch". I created a grid on the form. When I run the form, I can only get data to save for the row my cursor is on. I can see the gold diamond icon for each row that I change. But when I click on the Save button in the toolbar. Only the row I'm currently on will save.
I created another form using the "Classic" category in the New Form Wizard. I selected "GridOnly". This form will update all rows that I change. Regardless where my cursor is.
I then compared the two forms. I can't find any differences that would cause them to save the data different.
- I looked at the Collection in the Details section. I see no differences between the 2 forms.
- I did change the Standard Options to "True" on the form created as "Build From Scratch" so that the toolbar buttons appear.
- I looked at the Properties for both grids. I see no differences between the 2 forms.
- I looked at the Properties for both forms. I see no differences between the 2 forms.
I'm not sure what else to look at. But there has to be some setting that causes forms created from "Build From Scratch" to have different behavior than forms created from "GridOnly". Does anyone have any suggestions on what to try next?