error check on another form

[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!)

 

[John Nurick]

The general idea would be to use VBA code in the AfterUpdate event
procedure of the combo box on Option_types that displays fruit_type_id.
But there may be lots of complications.

For example,

1) can you guarantee that whenever the user selects a fruit_type_id on
Option_types, both the fruit_types form and the fruit_life subform will
always be (a) open and (b) displaying the relevant records?

If not, your code will have to find the relevant records in the
underlying tables: what are the tables and how are they related?

2) what do you mean by "complete"?