redraw a list box on another form

[Peter Morris]

Here's the situation.

I have a form MAIN_FORM which displays a list box LST_MYLIST.
The box displays data from table MY_TABLE.

If I click on a button I display another form FRM_NEW_ENTRY. On this
form I can enter data. When I click the "save" button on my form I
want to run code that does the following:

1) Writes the new data to MY_TABLE
2) redraws/ refreshes LST_MYLIST so it shows the new row
3) closes FRM_NEW_ENTRY

No 1 & 3 I can do, but what is the syntax for redrawing the list box?

TIA

 

[Marshall Barton]

Here's the situation.

I have a form MAIN_FORM which displays a list box LST_MYLIST.
The box displays data from table MY_TABLE.

If I click on a button I display another form FRM_NEW_ENTRY. On this
form I can enter data. When I click the "save" button on my form I
want to run code that does the following:

1) Writes the new data to MY_TABLE
2) redraws/ refreshes LST_MYLIST so it shows the new row
3) closes FRM_NEW_ENTRY

No 1 & 3 I can do, but what is the syntax for redrawing the list box?

Forms!MAIN_FORM.LST_MYLIST.Requery

 

[Peter Morris]

Forms!MAIN_FORM.LST_MYLIST.Requery

Thanks, that worked.

 

[Richard W. \(Rich\) McCabe]

Peter, What about LST_MYLIST.REQUERY?
Rich

 

[Peter Morris]

Here's the situation.

I have a form MAIN_FORM which displays a list box LST_MYLIST.
The box displays data from table MY_TABLE.

If I click on a button I display another form FRM_NEW_ENTRY. On this
form I can enter data. When I click the "save" button on my form I
want to run code that does the following:

1) Writes the new data to MY_TABLE
2) redraws/ refreshes LST_MYLIST so it shows the new row
3) closes FRM_NEW_ENTRY

No 1 & 3 I can do, but what is the syntax for redrawing the list box?

TIA

Thanks for your help on this.

Another one, same as above except this time its not a list box but
a subform that I wish to update. Call it SUB_MYSUBFORM