I have navigation form with different tabs.
One of tab is connected to a form “FormA” and this form has a combobox with limit to list items.
This combobox list items are sourced from a table.
But infront of this combox is button to pop up a form “AddTypeForm”, by this user can add more items to combobox list. So basically record will be saved in a table, which appears in combobox list.
Problem:
Record added to combobox wont show up immediately, after closing the popup form. Even I tried to requery that form on close.
It only works, if I move in between tabs on main form and come back to that form containing combobox, then it show the record which I added recently.
It means basically, it works only if form is reloaded.
Let me assume Names.
MainForm (Containing tabs for navigating other forms)
FormA (which has combobox)
AddTypeForm (which pops up to add records to combobox list).
Main form is giving the same name to all subforms under each tab.
I tried
Forms!MainForm!NavigationForm.Requery
This works for date filters etc, but wont bring freshly added combo list item, unless I move around tabs. Note: Database is splitted into front and back end.
One of tab is connected to a form “FormA” and this form has a combobox with limit to list items.
This combobox list items are sourced from a table.
But infront of this combox is button to pop up a form “AddTypeForm”, by this user can add more items to combobox list. So basically record will be saved in a table, which appears in combobox list.
Problem:
Record added to combobox wont show up immediately, after closing the popup form. Even I tried to requery that form on close.
It only works, if I move in between tabs on main form and come back to that form containing combobox, then it show the record which I added recently.
It means basically, it works only if form is reloaded.
Let me assume Names.
MainForm (Containing tabs for navigating other forms)
FormA (which has combobox)
AddTypeForm (which pops up to add records to combobox list).
Main form is giving the same name to all subforms under each tab.
I tried
Forms!MainForm!NavigationForm.Requery
This works for date filters etc, but wont bring freshly added combo list item, unless I move around tabs. Note: Database is splitted into front and back end.