Hello,
I have a parent form with 2 subforms. The "Job History" subform displays information on jobs via query (Job Number, Customer, Date Requested, Date Scheduled, Driver, Vehicle etc.) The other is a subform for the data entry that sources from the "Job" table ("Job Details"). I have succeeded in joining the two subforms with an unbound text control.
The process in which the data is entered occurs in two phases. An employee enters a 'request' which provides Job Number, Customer, and Date Requested. In this phase, the 'dispatch' aspect of Date Scheduled, Driver, and Vehicle remain Null to be entered in Phase 2. The entry for both phases occurs in the same subform "Job Details"
I want my query to display all jobs, whether dispatched or not, and show empty fields for nulls (Jobs that are open and not yet scheduled). Currently, my query only displays jobs that have ALL information (Requested and Dispatched), and working with the nulls has been tricky. I know nulls are a beast to work with if the theory is not understood, and I've searched for ways to work with them appropriately. The dispatch data is missing/unknown. I've set my query criteria to display "Or 'Is Null" as a condition. The fields should not require input at the request phase, as that's not appropriate to the process. The dispatcher should be able to view unscheduled jobs and fill them in at a later time.
How would a pro develop the display of a query that works in multiple phases, as mine does? Better yet, is the solution simple enough for a vb noobie?
Thanks in advance!
I have a parent form with 2 subforms. The "Job History" subform displays information on jobs via query (Job Number, Customer, Date Requested, Date Scheduled, Driver, Vehicle etc.) The other is a subform for the data entry that sources from the "Job" table ("Job Details"). I have succeeded in joining the two subforms with an unbound text control.
The process in which the data is entered occurs in two phases. An employee enters a 'request' which provides Job Number, Customer, and Date Requested. In this phase, the 'dispatch' aspect of Date Scheduled, Driver, and Vehicle remain Null to be entered in Phase 2. The entry for both phases occurs in the same subform "Job Details"
I want my query to display all jobs, whether dispatched or not, and show empty fields for nulls (Jobs that are open and not yet scheduled). Currently, my query only displays jobs that have ALL information (Requested and Dispatched), and working with the nulls has been tricky. I know nulls are a beast to work with if the theory is not understood, and I've searched for ways to work with them appropriately. The dispatch data is missing/unknown. I've set my query criteria to display "Or 'Is Null" as a condition. The fields should not require input at the request phase, as that's not appropriate to the process. The dispatcher should be able to view unscheduled jobs and fill them in at a later time.
How would a pro develop the display of a query that works in multiple phases, as mine does? Better yet, is the solution simple enough for a vb noobie?
Thanks in advance!
