form/subform question

[tope12]

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?

 

[Marshall Barton]

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.