Next question - prepopulating a field on a form

  • Thread starter Thread starter CCB
  • Start date Start date
C

CCB

I have a number assigned to each 'customer' in my database. On multiple tabs
in my form how do I get the data entered from the main customer screen to
populate in view only mode on all the other screens so the data is
consistent? I don't want to re-enter this number on each tab.
 
Hi, CCB.

Just place another textbox bound to the same field, with its Locked property
set to Yes.

Hope that helps.
Sprinks
 
I have a number assigned to each 'customer' in my database. On multiple tabs
in my form how do I get the data entered from the main customer screen to
populate in view only mode on all the other screens so the data is
consistent? I don't want to re-enter this number on each tab.
Click to expand...

The data entered in the main customer table should certainly not be
*stored* in any of the related tables!

If you have a Tab Control on your form, you may want to size the
control so that there is room above it to display the constant data:
this is simple and efficient.

If your tabs cover the entire screen, you can put controls on each
tab, all with the same Control Source, to display the data on each
tab. These controls should be locked to prevent the user from trying
to change the data.

John W. Vinson[MVP]
 
Back
Top