Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Post Unanswered: Subform sourceobject a table?

    I don't have a clue here. Usually this works like a charm.

    Through a small menu the user gets to import an excel shell, which is imported to a specific tablename.

    The menu has a subform. Once the sheet is imported I want to assign the newly imported sheet (that is, table) to the subform.

    Code:
    sub_ima_match.Visible = True
    sub_ima_match.SourceObject = sdeg_tbl_ima (the name of the table)
    Setting it manual via the properties sheet works flawlessly, but through the code I simple get various errors. I'll post a few errors in a minute or so.

    /Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Your minute or so is up.

    I suspect the property expects a string, so try:

    sub_ima_match.SourceObject = "sdeg_tbl_ima"
    Paul

Posting Permissions

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