Update Query after operation 1

[Xenocide]

I have a listbox linking to a certain query.

I would like it to refresh after I add some information in my databse without having to close the forms or something like that

I tried something like that

Private Sub Form_AfterInsert()
Me.lst3.Requery
End Sub

but it doesn't work can someone help me please?
thanks you

 

[RoyVidar]

The after insert event of the form fires after a new record is inserted. Perhaps try the on current event (the after update event could also be an option, but I'd favour the on current)?

Roy-Vidar

 

[Xenocide]

thanks for the help but it doesn't work either.. the list doesn't update after the table have been updated

 

[PHV]

And this ?
Me!lst3.RowSource = Me!lst3.RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

How do you update the table? If it's done in code, add the requery, or PHV' suggestion at the end of that code.

Roy-Vidar

 

[Xenocide]

Thanks a lot guys

PHV suggestion worked really well althoght since I'm directly in the forms I don't need the ! but . instead