Please help with this form

[de049]

Hi all,

I can't get the following to work on my DB. I want to get a pop-up form the will appear whenever I press the ADD RECORD button on my Maion form. This pop-up form should contain the texboxes that are already displayed on the main form so that the user can fill in the new record, and that when I save and close this pop-up form, the list in the unbound listbox will be updated to show the new entry.

The DB Design I'm using is based on OldSoftboss's "SearchExample02.zip", which has a single form and basically contains a listbox that displays certain records from the table. The form has textboxes that display all the records held in the table as well as a search facility (textbox) that searches the listbox for the given criteria.

Please help!

Many thanks

 

[Pat Hartman]

You don't say what doesn't work so I'm going to guess that the RowSource for the listbox isn't showing the new record. To solve that problem, add one line of code to the AfterUpdate event of the popup form:

Forms!YourMainForm!YourListBox.Requery