Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178

    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.

    Any ideas?

    Thanks,

    Sam

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    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.

    I guess it's back to the drawing board.

    Thanks anyway,

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •