Display "Null" data/records in subform with Filter

[ggodwin]

I am trying to create a form that will help engineers know what they need to do. Basically, create an open item list on a subform for all records that have a NULL value in ProblemDescription in the QREVALUE Table.

My Main Form is called QRE VALUE.

I have just 11 fields in the table and I don't need to display all of them.
I just want to display these fields 3.

TagNumber
QPRQPINumber
ProblemDescription

I would like to select the field in the subform and have it highlight the record in the main form. ( So that the user can enter the information if they chose or see all the fields and their content)

I would also like to have a listbox to make a selection that would allow me to filter the data. Basically something with 4 Names on to chose from. This could be a tabbed menu or listbox or what ever. (This is so that each user could see "their" open items rather than sorting through others.

 

[tranchemontaigne]

Re: Display "Null" data/records in subform with Filter

HIGHLIGHTING RECORD IN PARENT FORM:
Not knowing the exact relationship between the data in the parent form and subform I'll take a guess that the parent form diaplays a list of all records and the subform displays details.

What you will ultimately need to do is figure out the value of the key of the subform record and then set the value of the control displaying all records in the parent form to be equal to that value.

I admit that I do't understant exactly what you are looking for here.

FILTER QUESTION:
I never really liked using filters. I prefer to reset the rowsource property of a listbox based upon a click event. Usually I do the following to solve this kind of problem

(1) build the base SQL statement in code
(2) dynamically write the WHERE clause
(3) concatenate the lot together
(4) reset the rowsource property to the SQL statement that was created in step (3)

This method will give you the same results but I find it easier to wrap my brain around.
________
SC2 REPLAYS