I am attempting to write code on double click: go to the record in the same from the selected list lst.column(0) in VBA. I have written it in the macro within access, but cannot add additional code after that. I need to requery a list in the child form based on the information from the parent form. I keep banging my head on the wall.
Attempted
Docmd.SearchForRecord but the table has to be open..I even wrote to open the table run docmd.SearchForRecord and close table, but no go.
Docmd.GoToRecord
Putting the code for the refresh works by placing it in vba on the even on lost focus, but I do not like that fact that they have to click somewhere else for the list to update.
Issues issues issues issues issues issues! Anyone have an idea?