Setting the form dataentry property via vb?

[jim Bob]

Hi,
I have a search form and upon double click on a name in the list box, a
Candidate details form pops up. (no edits etc allowed, only viewing). I
have a second form in dataentry mode which is in the exact format as
Candidate details form.

I need a way to set the data entry or edit properties to yes or no do i
can just use vb to open up the 1 form.

would it be something like
dataentry = "yes" ??

Thanks

*** Sent via Developersdex http://www.developersdex.com ***

[Br]

jim Bob wrote:

Hi,
I have a search form and upon double click on a name in the list box,
a Candidate details form pops up. (no edits etc allowed, only
viewing). I have a second form in dataentry mode which is in the
exact format as Candidate details form.

I need a way to set the data entry or edit properties to yes or no do
i can just use vb to open up the 1 form.

would it be something like

Look at the property sheet of the form. Note what you see. There are a few
properties that may effect the editting of data (assuming the recordset is
editable in the first instance:)

eg.

Allow Edits y/n
Data Entry y/n

To access these properties in VB type...

Me.

And then a list of all the form's properties should appear. You then give it
the value you'd like.

eg.

Me.AllowEdits = True

Look up the Access help if you need more info about the properties.
--
regards,

Br@dley

[jim Bob]

thanks for that. Just tried it but it doesn't seem to work.
I'm using the code like this.

Private Sub btnSandE_Click()

DoCmd.OpenForm "frm_EditCandidateInfo", , , "DatabaseID = " &
Me.qmyList.Value

Me.AllowEdits = False
Me.AllowAdditions = False
Me.DataEntry = False

End Sub

It doesn't feel right. hmm.
Cheers

*** Sent via Developersdex http://www.developersdex.com ***

[Br]

jim Bob wrote:

thanks for that. Just tried it but it doesn't seem to work.
I'm using the code like this.

Private Sub btnSandE_Click()

DoCmd.OpenForm "frm_EditCandidateInfo", , , "DatabaseID = " &
Me.qmyList.Value

Me.AllowEdits = False
Me.AllowAdditions = False
Me.DataEntry = False

End Sub

It doesn't feel right. hmm.

You've got to explain what you want to achieve and what is actually
happening.

--
regards,

Br@dley

[Br]

jim Bob wrote:

thanks for that. Just tried it but it doesn't seem to work.
I'm using the code like this.

Private Sub btnSandE_Click()

DoCmd.OpenForm "frm_EditCandidateInfo", , , "DatabaseID = " &
Me.qmyList.Value

Me.AllowEdits = False
Me.AllowAdditions = False
Me.DataEntry = False

End Sub

It doesn't feel right. hmm.
Cheers

If you are trying to make a popup form editable/readonly dynamically why not
just open the whay you want:

eg.

docmd.OpenForm "myForm" ,,,,acFormReadOnly

--
regards,

Br@dley

[jim Bob]

Solved the problem.

ended up using:
GBL_DBID = Me.qmyList.Value
DoCmd.OpenForm "frm_SearchResults", , , , acFormEdit

(using global variables). Not ideal but it allows me to open 1 form in 3
different places with varying attributes.

Cheers.


*** Sent via Developersdex http://www.developersdex.com ***

[Br]

jim Bob wrote:

Solved the problem.

ended up using:
GBL_DBID = Me.qmyList.Value
DoCmd.OpenForm "frm_SearchResults", , , , acFormEdit

(using global variables). Not ideal but it allows me to open 1 form
in 3 different places with varying attributes.

Why not use a where clause when you open the form?

eg..

DoCmd.OpenForm "frm_SearchResults", , ,"[DatabaseID ] = " & Me!qmyList.Value
, acFormEdit

? :)

--
regards,

Br@dley

[Bob Quintal]

jim Bob <fr****@gmail.com> wrote in news:XAfCf.609$635.10575
@news.uswest.net:

thanks for that. Just tried it but it doesn't seem to work.
I'm using the code like this.

Private Sub btnSandE_Click()

DoCmd.OpenForm "frm_EditCandidateInfo", , , "DatabaseID = " &
Me.qmyList.Value

Me.AllowEdits = False
Me.AllowAdditions = False
Me.DataEntry = False

End Sub

It doesn't feel right. hmm.
Cheers

*** Sent via Developersdex http://www.developersdex.com ***

in this code, me.AllowEdits refers to the form that you just
clicked. I think you want to refer to the form you just opened,
frm_EditCandidateInfo

refer to the form as
Forms!frm_EditCandidateInfo.AllowEdits = False
--
Bob Quintal

PA is y I've altered my email address.