dialog form data

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Question regarding use of a dialog form in Access 2003.
On one of my forms I have a listbox that displays a
concatenation of three data fields (array).
To change one or more of these data points on a selected
row in the list, I use a separate dialog form.
After a choice is altered on this dialog form, you are
returned to the original form where the listbox data is
refreshed.
But other data on that same form depending on the new
data is NOT updated. Furthermore, the selected row in the
listbox returns to the uppermost row, not the selected
row, where I would like it to be... highlighting the data
row that has been changed. I have tried opening the
dialog form using an open argument that relates the list
index, so when you return to the original form I can
transmit this list index back to selected row, but it
does not work. I try to invoke it using an event like 'on
current' or on 'resize' but it does not work.
Any ideas?
 
Todd,

I am assuming that you are opening the Dialogbox in Dialogmode from the
original form to stop execution, ,then resuming, Like:

DoCmd.OpenForm "myForm", , , , , acDialog

Try

Me.Refresh

as the next line or somewhere after the Dialogbox is open. It "should"
refresh the listbox as well as the formdata. If that doesn't work, try a
Save operation on the Dialogbox before you close it, maybe on the exit
button, Like;

DoCmd.RunCommand acCmdSaveRecord

God Bless,

Mark A.Sam
 
Back
Top