Hi all, I am using an unbound form to select the data in my subform and save it in my table, I have a textbox and search button on my form, so i will have to key in the PO number then click on search so that the subform will display all the record set that is under that PO number.
Next the issue is that after i click save to save the record to my table, it will refresh the subform table, with that i will have to key in the same PO number and search again before i can continue saving other record set that is under that PO number to my table.
How can i prevent the table from refreshing? so that even if i save, the subform will still show the other record that has not been saved in my table?
Next the issue is that after i click save to save the record to my table, it will refresh the subform table, with that i will have to key in the same PO number and search again before i can continue saving other record set that is under that PO number to my table.
How can i prevent the table from refreshing? so that even if i save, the subform will still show the other record that has not been saved in my table?