Use a form for data Entry

[Wavequation]

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?

 

[Stuart McCall]

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?

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

DoCmd.OpenForm "MyFormName", , , ,acFormAdd

 

[fredg]

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?

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.

 

[John W. Vinson]

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?

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]