Use a form for data Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I use to review information about components. Can I open
the same for for dataentry, by changing the DataEntry property in VBA when
the form opens?
 
Wavequation said:
I have a form that I use to review information about components. Can I
open
the same for for dataentry, by changing the DataEntry property in VBA when
the form opens?
Click to expand...

Better than that, you can set the datamode in the OpenForm call:

DoCmd.OpenForm "MyFormName", , , ,acFormAdd
 
I have a form that I use to review information about components. Can I open
the same for for dataentry, by changing the DataEntry property in VBA when
the form opens?
Click to expand...

Sure, but if you want to use the same form for data display and for
data entry, why not just change the form's DataEntry property to No.
The form will open and you can view, edit and add new records.
 
I have a form that I use to review information about components. Can I open
the same for for dataentry, by changing the DataEntry property in VBA when
the form opens?
Click to expand...

You can add new records even WITHOUT changing the data entry property. All
that property does is to let you add new records but to *prevent* you from
viewing existing records.

Just click the *> icon on the navigation buttons to go to the new record - or
you can use the command button wizard to add a custom button to do the same
thing.

John W. Vinson [MVP]
 
Back
Top