updating a listbox

[rew]

Hi,
I've a listbox. Once i doubleclick on a data on this listbox an editing form will open.
I modify my data, save, close. But the data on the listbox are the same as before..
how can i update this data?? Something like once i saved & closed the editing form the listbox will update....don't know..
i've tried stuff like requery,refresh, ... but didn't work.. (was my mistake maybe)..
thx in advance

 

[RuralGuy]

Open your other form with the acDialog argument to halt the code in the first form. Then your Me.ListBoxName.Requery when you get back will work.

 

[rew]

Open your other form with the acDialog argument to halt the code in the first form. Then your Me.ListBoxName.Requery when you get back will work.

mh, i'm not sure i get it..
now i've something like this

Private Sub List2_DblClick(Cancel As Integer)
DoCmd.OpenForm "inserimento_cliente", , , "[CLI_ID] = " & Me.List2, , acWindowNormal

End Sub

i've to put Me.List2.Requery after that?
i've already tried but isn't working.
I mean..it works once you doubleclick again on a record..not when you close&save the other form (named "inserimento_cliente")

thx again

 

[RuralGuy]

Try this:

Private Sub List2_DblClick(Cancel As Integer)
DoCmd.OpenForm "inserimento_cliente", , , "[CLI_ID] = " & Me.List2, , [b]acDialog[/b]
Me.List2.Requery

End Sub

The acDialog argument will halt all of the code in the current form and not start it again until you close the next form.

 

[rew]

Try this:

Private Sub List2_DblClick(Cancel As Integer)
DoCmd.OpenForm "inserimento_cliente", , , "[CLI_ID] = " & Me.List2, , [b]acDialog[/b]
Me.List2.Requery

End Sub

The acDialog argument will halt all of the code in the current form and not start it again until you close the next form.

thx a lot! it works

 

[RuralGuy]

You're welcome. Thanks for posting back with your success.