I need to create a data entry form for atable. When the form is opened, it shoul

Question

I need to create a data entry form for atable. When the form is opened, it should go to a blank form BUTallow the user to edit pre-existing records. How can I do that? becuase if I changethe Data Entry property to Yes, it won't allow me to modifypre-existing records. Help please! I need to create a data entry form for atable. When the form is opened, it should go to a blank form BUTallow the user to edit pre-existing records. How can I do that? becuase if I changethe Data Entry property to Yes, it won't allow me to modifypre-existing records. Help please!

Explanation / Answer

Then goto "Event" tab in form properties. In the On Open event box ...click on the loadbutton(shown by dots inside a box). Then select Macro Builder. In Macro Builder you will get a box with a green plus sign tothe left. The box has a drop down menu. Open it and selectGoToRecord. In that option in the Record field select New. Now save the whole thing and close it. You will be back to the form properties event tab. Repeat the above procedure for the On Load event.
and you're done.
PS: if you have no button or method of your own for updatingthe database, then in the event tab of the form properties dialogbox, goto On Close event, browse to macro builder and there selectthe macro action : "Save Record" from the drop down menu.this saves your records automatically when you close theform.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.