I am trying to open a form in VBA, have the user double click on a row, get a value from that row and use it in an underlying form. Problem is that even if I set the form properties to Modal = Yes and Popup = Yes, the program doesn't wait for the form to close, the code continues with the open form in the background. I need for the form to be opened and the code to "wait" until one way or another that form is closed. Any ideas?
varfilter = "[USER] =" + "'" + VSelUser + "'"
VSelUser is set during the dblclick event in the "users" table.