beginners query question (1 Viewer)

[dan-cat]

Hope you can help. After a field is updated I want to run a select query. However I don't seem to be able to run this query without opening the query and then closing it via a macro. This looks really clumsy to me. Is there anyway of updating the query once a field is updated without having to open and close it?
Many Thanks

Dan

 

[Rich]

Save the record first, in code it's DoCmd.RunCommand acCmdSaveRecord