error check on another form

  • Thread starter Thread starter hass via AccessMonster.com
  • Start date Start date
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!)
 
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"?
 
Back
Top