mpoincare
July 7th, 2005, 09:22 AM
I have a listbox on a main form in MS Access 2000 named 'frmMain' that shows information based on table named "contacts". There is on this form a button that triggers an onclick event that opens an other form name 'frmContact' that allows to input a new contact. What I want now is for the new contact to be shown in the listbox on the form 'frmMain'. After the instruction on the form 'frmContact' that adds the new contact, I used the instruction: Forms!frmMain!lstContact.Requery. But the new contact entered is not showing on the list. Right after this instruction, I used the instruction: Forms!frmMain.Refresh. And still the new contact entered is not showing. Does anybody have any clue why the new contact entered is not showing on the listbox on 'frmMain'?