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)
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.