After Update Event

  • Thread starter Thread starter Ms-Exl-Learner
  • Start date Start date
M

Ms-Exl-Learner

After Update Event

Hi All,

I am having a table like the below:-

Table Name : DCData

Field Name Type
Document Presented Yes/No
Date Date/Time

I have created a form Using Wizard and get the fields from DCdata Table to
my form.

Form Name: DCData (F)

I require a after update event macro for my [Document Presented] field
(Yes/No) if the person check the [Document Presented] check box then the form
should show the [Date] field otherwise if it is unchecked then the [Date]
field should not be visible and cannot be accessed by the users. (Using
Access 2003)

Awaiting for your reply.
 
I don't write macros, but here's some VBA code:

Private Sub Document_Presented_AfterUpdate()
If Me.[PDocument Presented] = True Then
Me.[Date].Visible = True
Else
Me.[Date].Visible = False
End If
End Sub

You will also need to use similar code in the form's current event.
 
Thank you very much!!!

--------------------
(Ms-Exl-Learner)
--------------------


Arvin Meyer said:
I don't write macros, but here's some VBA code:

Private Sub Document_Presented_AfterUpdate()
If Me.[PDocument Presented] = True Then
Me.[Date].Visible = True
Else
Me.[Date].Visible = False
End If
End Sub

You will also need to use similar code in the form's current event.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


Ms-Exl-Learner said:
After Update Event

Hi All,

I am having a table like the below:-

Table Name : DCData

Field Name Type
Document Presented Yes/No
Date Date/Time

I have created a form Using Wizard and get the fields from DCdata Table to
my form.

Form Name: DCData (F)

I require a after update event macro for my [Document Presented] field
(Yes/No) if the person check the [Document Presented] check box then the
form
should show the [Date] field otherwise if it is unchecked then the [Date]
field should not be visible and cannot be accessed by the users. (Using
Access 2003)

Awaiting for your reply.
Click to expand...


.
Click to expand...
 
Ms-Exl-Learner said:
After Update Event

Hi All,

I am having a table like the below:-

Table Name : DCData

Field Name Type
Document Presented Yes/No
Date Date/Time

I have created a form Using Wizard and get the fields from DCdata Table to
my form.

Form Name: DCData (F)

I require a after update event macro for my [Document Presented] field
(Yes/No) if the person check the [Document Presented] check box then the
form
should show the [Date] field otherwise if it is unchecked then the [Date]
field should not be visible and cannot be accessed by the users. (Using
Access 2003)

Awaiting for your reply.
Click to expand...
 
Back
Top