Unanswered: .OpenQuery method with parameter query
I want the user to be able to edit a recordset that is created by a parameter query. The only way I know how to allow datasheet view is with the .OpenQuery method. The problem is, I can't get it to take a parameter.
I know I can put the data in a table and edit it from there; I'm looking for a more efficient way of doing it.
Never mind. I realize that the only way for the info to be displayed in a way the user can modify it is if I put the data into a listbox in another form which I open in Dialog mode. Otherwise the datasheet's open and the VBA routine continues on its merry way.