Call query after update

[lauraSatellite]

I have a Primary Key drop down list which has a query as its source. Currently when i insert a new record, i have to close out of the form, and re-enter it to have an up-to-date drop down list.
I need the drop down list to "refresh" or call its source query again after the update occurs.
I have tried this:

Private Sub Form_AfterUpdate()
Me.RecordSource = Me.SourceQuery.QueryField
End Sub

I am new to procedures, if you have any useful tips they would be very much appreciated.

 

[PHV]

Have you tried this ?
Private Sub Form_AfterInsert()
Me![name of combo].Requery
End Sub

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

 

[lupins46]

You've got the right event procedure.

Put:
me.cbocomboname.requery

where cbocomboname is the name of your combo box.

 

[lauraSatellite]

thank you both very much!
that worked perfectly