I have a form with two textboxes in it. I also added a subform to it. On the 
beforeupdate event of each form, i set it up to prompt the user about saving 
the data. My question is: Is there a way to set it up so that it only prompts 
you once and perform the actions(save or discard data) on both the main form 
and subform?

My other question is:

          Can you link textboxes to values in listboxes just as you can do 
with subforms and textboxes? 

tope12 wrote:

>I have a form with two textboxes in it. I also added a subform to it. On the 
>beforeupdate event of each form, i set it up to prompt the user about saving 
>the data. My question is: Is there a way to set it up so that it only prompts 
>you once and perform the actions(save or discard data) on both the main form 
>and subform?

If the forms are bound, then the main form's data is saved
automatically as soon as the focus moves into a subform and
vice versa.   This means that there is no reason to prompt
users to save anything.

OTOH, if you are using unbound formsm then you can do most
anything, but it's a ridiculous amount of work fo so little
benefit.


>My other question is:
>
>          Can you link textboxes to values in listboxes just as you can do 
>with subforms and textboxes? 

A text box expression can reference the value of a single
select list box.  Multi select list boxes do not have a
value so there is nothing to retrieve.

-- 
Marsh
MVP [MS Access]