-----Original Message-----
I am pretty new to Access and am slowly teaching myself
how to work it. I have successfully imported my tables
previously in Excel over and created forms, but whne i go
to add a new record in form view it will not allow me to
do it. How do i change it so that I can add a new record
by just opening the form i have
Set the form properties to allow additions, allow edits,
and allow deletions. Then set it to data entry, so that
when you open your form its a blank slate. Save it
as "Form_Enternew" or somesuch, export the new form to the
same database, rename it "Form_View" and take off data
entry. You now have 2 identical forms, 1 for new entries,
one for viewing/editing. Now all you need is a menu to
link them both together. =)
Edm