form/subform question

  • Thread starter Thread starter tope12
  • Start date Start date
T

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?
 
tope12 said:
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?
Click to expand...

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?
Click to expand...

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.
 
Back
Top