H
hass via AccessMonster.com
Hi
Im trying to create a sort of 'check' in a form and was wondering if someone
can help...im really new to access and v.v.stuck!
here's the background to my database
at present, i have a form (fruit_types) which has a subform(fruit_life) -
within fruit_life, is a combo_box which shows data from another table
(fruit_carton) - Data input is compulsory in fruit_carton and fruit_type but
NOT fruit_life (subform) - however...when the user enters another form called
Option_types, the user must select a fruit_type_id (from a combo box). After
a select is made, it's here i would like a 'check' to occur to see if
fruit_type AND fruit_life are complete....if fruit_life is not, a msgbox
should come to say 'sorry, incomplete data in fruit_life" and the data
inputted in option_type form is not saved....
Does anyone know how this can be achieve? (i jst need advice!)
Im trying to create a sort of 'check' in a form and was wondering if someone
can help...im really new to access and v.v.stuck!
here's the background to my database
at present, i have a form (fruit_types) which has a subform(fruit_life) -
within fruit_life, is a combo_box which shows data from another table
(fruit_carton) - Data input is compulsory in fruit_carton and fruit_type but
NOT fruit_life (subform) - however...when the user enters another form called
Option_types, the user must select a fruit_type_id (from a combo box). After
a select is made, it's here i would like a 'check' to occur to see if
fruit_type AND fruit_life are complete....if fruit_life is not, a msgbox
should come to say 'sorry, incomplete data in fruit_life" and the data
inputted in option_type form is not saved....
Does anyone know how this can be achieve? (i jst need advice!)