Hi All,
i have a drawing database that is constantly evolving... and i have an odd issue.
https://www.dropbox.com/s/grp4jhaa78ls9t2/Database%20Overview.jpg?dl=0
When the database opens 2 forms are opened... (I attached an image on the link)
1 Form is the search and add new drawings sections
and the second Form is the current progress window for the drawings.
All the information are shown in various listboxes (of which are displaying data from queries)
When i add a new drawing a pop up window opens asking the person to enter information. Once entered you press a button and it closes the popup window and refreshes the list boxes in the 2 forms.
The form 'Drawings' listboxes updates fine....
But the second form list boxes do not refresh. To get the information to show in the listbox i have to press a refresh button... then it appears the in the listbox.
The code i am using is;
Forms![frm_main]![List14].Requery
Forms![frm_currentdrawing_stum]![List42].Requery
the frm_main works fine... the frm_currentdrawing does not.
Anyhelp would be appreciated!
i have a drawing database that is constantly evolving... and i have an odd issue.
https://www.dropbox.com/s/grp4jhaa78ls9t2/Database%20Overview.jpg?dl=0
When the database opens 2 forms are opened... (I attached an image on the link)
1 Form is the search and add new drawings sections
and the second Form is the current progress window for the drawings.
All the information are shown in various listboxes (of which are displaying data from queries)
When i add a new drawing a pop up window opens asking the person to enter information. Once entered you press a button and it closes the popup window and refreshes the list boxes in the 2 forms.
The form 'Drawings' listboxes updates fine....
But the second form list boxes do not refresh. To get the information to show in the listbox i have to press a refresh button... then it appears the in the listbox.
The code i am using is;
Forms![frm_main]![List14].Requery
Forms![frm_currentdrawing_stum]![List42].Requery
the frm_main works fine... the frm_currentdrawing does not.
Anyhelp would be appreciated!
