Hi all,
Please help.
I would like to get some information that can spark me to create an idea to solve my problem.
I have a form, it has a grid to display data from its view. This view is from a query.
In this view, I have a column called Invoice.
Now I have a new table storing a invoice name and its assigned number. I would like to also display this assigned number.
Then I add this table in the existing query.
I open my view after I add the table, the view is viewable.
Then I go to my form and add a new field from this view to display the assign number.
When I save the form and compile, error message popped up:
Unable to save Control ____(The field I newly add)____ .
Please advise which part may be wrong and resulting this problem. Many thanks in advance.
Kind Regards,
*This post is locked for comments
Yes the grid's Data Source is a view.
And this view is composed of 1 parent table and 2 child tables.
One child tables is added newly.
The expected new column is from this table.
I can open the view after modified. Yet I cannot add a field to view it in the form.
Many thanks for reply again.
also check if the grid is bound with table group instead of individual fields.
that case you have to add field to table group. or change the grid property to remove the group.
Hi Amir,
I have tried to restore the form and reassign the data source,
when I restore the data source, the field I added is removed.
Yet thanks for the help.
Hi Amir
Thanks for the fast reply, let me take a took on it.
are you able to view the correct data in view ?
then it should not be more than a refresh issue, try restore and refresh that form and data source on that form.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156