Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2011
    Posts
    24

    Unanswered: Specify column of source field to use as default in another form

    Hello I have a form where the user selects criteria such as the managers name and then the associates name. I then have another form they can access off of this one where they can fill in survey information for specific associates, I want the associate name field defaulted to the name that was selected in the first form, I put in the formula =[Forms]![frmName]![Associate], the problem I am having is that the field in the first form is based on a drop down list with 2 coulumns, 1 the assciate ID and then 2 the associate name, the form is showing column 2, but on the other form where I defaulted the value to. the associate ID is showing instead of the name. Anyone know how I can specify which column is displayed from the source field?

  2. #2
    Join Date
    Jan 2012
    Posts
    97
    Try:

    =[Forms]![frmName]![Associate].[column](1)

    Column 0 is the first column, 1 the second and so on...
    Hope this helps,

    Dave.

    _____________

    Access 2000 User

  3. #3
    Join Date
    Apr 2011
    Posts
    24
    Dave you are a beautiful genius, worked perfectly thank you very much.

  4. #4
    Join Date
    Jan 2012
    Posts
    97
    Your welcome.
    Hope this helps,

    Dave.

    _____________

    Access 2000 User

Posting Permissions

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