How to refresh a table in a form
The problem I am having is:
- Select a code in a combo box which is in main form
- Click a button on the form
- Another form opened with all the data displayed in tabular format related on the code selected
- Back to the main form, select another code in the combo box,
- “#delete” is shown on all of the cells of the table
How can I refresh the fields on the second form before it has the data of second code shown? (or display data instead of "#delete")?
I cannot use button Close to close the form first, then select another code from the combo box.
I thought that it would work if adding some code in the programm to close the form before it is opened, but fail.
Thanks for any suggestion,