Create a Data Entry Form in Microsoft Access OR Open an Existing Form in Data Entry Mode

In this video, I'm going to to teach you what a Data Entry Form is. You'll see how to take an existing form and make it a Data Entry Form. I'll also show you how to create two separate buttons to open a form normally, or in Data Entry mode.

Billie from Winnipeg, Manitoba (a Gold Member) asks: is there a way that I can have my secretary click a button and just start entering in new contacts for a customer? I don't really want her seeing the entire contact history, just log new calls and messages. Thanks!

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to open a form in Data Entry mode using VBA, and will also see how to password protect the "show previous contacts" button, and switch Data Entry mode OFF with one click.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, What is data entry, data entry forms, how do you do data entry, enter data into, Data Entry property, DataEntry, adFormAdd, ApplyFilter, cancel filter, cancel apply filter, disable filter

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[wlevzlr]

Hi; I have a table with some fields that have to be filled with Yes or No values. Depending on whether Yes or No value entered (selected) for each of those fields, data entry should then be done and continued in other tables of my need and interest and again after that the data entry operation should be returned to initial table and proceed there. Please let me know how this can be achieved using Forms for data entry. Many thanks for your prompt help

[TYapril]

This video from the beginning is to open an form, rather than HOW TO CREATE A FORM.

[brr]

hi i need help. i created a form but i can't add data to it. it says that bcs my data is related to other table. can u help me please?

[anybody_who]

This video's language may be set to "vietnamese". Please specify video language as "english"; then youtube will produce english subtitle correctly. (NB: currently it assumes video language vietnamese, and producing wrong subtitle.)

[botskie]

good day sir I always watching your video, I wanna request on how delete 1 record in a form with subform... I tried to do command in vba and when I try deleting 1st delete is ok and when I try to delete again it show "NO CURRENT RECORD"

This is the command Sir

If Not And Then

CurrentDb.Execute "DELETE FROM ClientDetails " & _
" WHERE ClientID=" &

ClientTrans.Form.Requery

End If

I Try This Also but same output

If Not And Then

CurrentDb.Execute "DELETE FROM ClientDetails " & _
" WHERE ClientID=" &

ClientTrans.Form.Requery

End If

I hope you Notice my Problem, thank you and Have a Nice day...