Results 1 to 3 of 3

Thread: Field Name

  1. #1
    Join Date
    Nov 2003
    Posts
    16

    Unanswered: Field Name

    I have a problem that i dont know how to approach. I created a form that displays the names of contact that have missing items. The user selects the item that is missing and the form generates a list of names. What i want to have happen is that when the user selects a name from the list of names, a list of all the missing fields for that name appear in another list box. The list i want to generate are field values for a table containing contact informaiton but i only want to display the fields that are missing ( that have a null value)

    If anyone has an idea how to do this let me know.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    To do this you would have to open a recordset of the record, Look at every field for null values and then build you SQl statement in code and execute you new statement and put that recordset into you list box. Plus several other things and then you have to keep tract of what field are in to which position in your sql statement, etc. Unless this is really important to you, it is going to be more of a hassle then it is worth.

    S-

  3. #3
    Join Date
    Nov 2003
    Posts
    16
    Thanks buddy

Posting Permissions

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