Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Unbounded Form and #Name?

    I have a Form whose RecordSource is not set yet, on that Form there are some textFields, how can I prevent #Name? when starting the Form?

    P.S
    The RecordSource of the form will be later during the process set to a table.
    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Hammy,

    When you say that the RecordSource will be set later ... HOW much later? After the form is displayed?

  3. #3
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    What's the current control source for the textbox? If it's nothing, you shouldn't get #Name(?).
    All code ADO/ADOX unless otherwise specified.
    Mike.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by M Owen
    Hammy,

    When you say that the RecordSource will be set later ... HOW much later? After the form is displayed?
    Thanks for your reply, in the fact I have the fields on the Form then when the user search for data, then at that point the fields should show its selected datat.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by M Owen
    Hammy,

    When you say that the RecordSource will be set later ... HOW much later? After the form is displayed?
    Yes after the form is displayed.
    I have the form, its TextBoxes are bounded, and its RecordSource is not set, then I display it waiting for the user to search for Data, If found, then the RecordSet will be set and the TextBoxes will be filled

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Hammy,

    I don't do it that way ... Just my thing. I wait until I have data before displaying the form ...

Posting Permissions

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