Can't Update records in form after input data in dialog form

[sadiqsabia]

I have this problem and not sure how to go around it.

I have a main form to enter data. The user can click on a button to open up another form which open in dialog mode.
This is what the problem is.

AFter enter data in dialog form , i want the list box in main form to be updated but when i close the dialog box the main form listbox is not updated. I have to use the refresh button on the menu to upate. I want this done automatically. When i close the dialog form. When i open the form in normal mode the record is updated automatically. Why is this so. Please help.

 

[boblarson]

You need to requery the listbox from the dialog form's On Close event.

So in the dialog form's On Close event put:

Forms!YourMainFormNameHere.YourListBoxNameHere.Requery

That should do it for you.

 

[sadiqsabia]

You need to requery the listbox from the dialog form's On Close event.

So in the dialog form's On Close event put:

Forms!YourMainFormNameHere.YourListBoxNameHere.Requery

That should do it for you.

thanks man.. If you could help
how to set the list box to point to the record i just enter in the dialog box or to the last record