Forms

[Guest]

Hi,

I don't want if I can d o it or not

In my form I want the user to be able just to enter Data, and if he want to
view data he has to click on open value and all the data will be load in this
form

Can I do that or no??

Thanks for any help

 

[Jonathan Parminter]

Hermione wrote

-----Original Message-----
Hi,

I don't want if I can d o it or not

In my form I want the user to be able just to enter Data, and if he want to
view data he has to click on open value and all the data will be load in this
form

Can I do that or no??

Thanks for any help
.

Hi Hermione.

use the following as an example.

The form has the initial setting of data entry as false.
Add a command button with the name; cmdDataEntry.
Have the caption; Data Entry.
copy the following code into the onclick() event.

**** code starts ****


Private Sub cmdDataEntry_Click()
Dim ctl As Control

Set ctl = cmdDataEntry
If ctl.Caption = "Data Entry" Then
Me.DataEntry = True
ctl.Caption = "View All"
Else
Me.DataEntry = False
ctl.Caption = "Data Entry"
End If

End Sub

**** code ends ****

luck
Jonathan