Good day everyone,
I am developing a simple Access program for my cousins Bus Company and he ask me to help him with the Preventive Maintenance Services
I am creating a report that depends the input from a combo box in a form.
Lets say i have 30 fields in the query, field1 is the to do list... field2 is for requisition... field3 is the priority (like change parts of the engine)... the remaining fields are the cycle of maintenance periods that defends on those kilometers that has been consumed like (12,000km, 24,000km, 36,000km, etc)
my problem is that how to do a condition(VB code) that put my <> No criteria on the field that i choose from combo box.
Note..
The remaining fields are all just check box in the the form (Yes/No in the table)..
Maybe there is someone here already did the same in their previous programs.
Can anyone help me please
Thanks in advance.
I am developing a simple Access program for my cousins Bus Company and he ask me to help him with the Preventive Maintenance Services
I am creating a report that depends the input from a combo box in a form.
Lets say i have 30 fields in the query, field1 is the to do list... field2 is for requisition... field3 is the priority (like change parts of the engine)... the remaining fields are the cycle of maintenance periods that defends on those kilometers that has been consumed like (12,000km, 24,000km, 36,000km, etc)
my problem is that how to do a condition(VB code) that put my <> No criteria on the field that i choose from combo box.
Note..
The remaining fields are all just check box in the the form (Yes/No in the table)..
Maybe there is someone here already did the same in their previous programs.
Can anyone help me please
Thanks in advance.