[MS_AccessPros] Need help with VBA procedure

 

Access 2010

On Form among several fields, four fields (PayDate, Time, PaidTo, and PaidFor) have the following procedures Before Update Event.

If Not IsNull(Me.PayDate.Value) Then

 PayDate.DefaultValue = "#" & Me.PayDate & "#"

End If

"To save space I just typed the first procedure."

 

And I have Button on the form with Embedded Macro:

OpenForm

            Form Name        SData

                      View          Form

         Filter Name              

Where Condition

          Data Mode          Add

  Window Mode              Normal

 

Problem is when I open a new form in add mode with this button all four fields already have data that I could not find them in all relate tables and quires to this form.

How can I prevent this problem?

 

__._,_.___

---

Posted by: kenaf42@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___