Form with extra optional data button

  • Thread starter Thread starter David
  • Start date Start date
D

David

I'm changing a system with an exisiting data entry form.
The main table will have a bunch of new data with a lot of
memo fields, all of which is optional in the row.

Rather than mess with the existing form, I want to add a
button to the main form to bring up a separate form with
the new fields.
How would I handle this? The main form will be bound to
the table, but what about the form reached by the button.
I have to handle updates on both forms or on either form
and not the other.
 
One thing I have seen done, and done myself, with text boxes for memo fields
is to put in the Click, DoubleClick, or GotFocus event, DoCmd.RunCommand
acCmdZoom. You can make them just large enough to see the first character on
the Form, but the automatic Zoom lets you see all that is there and gives
you room to work on data entry or editing.

And, if this does the job for you, you won't have any potential problems
with multiple forms open to the same record, inadvertent lock collisions,
etc.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
 
Back
Top