Time field question

[Guest]

I have the following in the DblClick event for the control CaseStart which is
a date/time field. The problem is that once the control is double clicked the
form remains in edit mode, even though I've told it not be editable.
Additionally, when the control is double clicked, it shoudn't enter in the
time until the Edit button has been clicked on the form. The form opens with
Me.AllowEdits = False, and this works for everything but the control at issue.

Me.CaseStart = Time()
Me.AllowEdits = False

I've also put the following in the control's after update event;
Me.Form.frmVisitNewEdit.AllowEdits = False
But to no avail.

As always, your help is greatly appreciated.

rob

 

[missinglinq via AccessMonster.com]

In Access2000 I've tried to reproduce this, Rob, but no luck! Even without
the following Me.AllowEdits = False code the form remains uneditable after
Time() is inserted into the double-clicked control!

Some kind of corruption maybe? What version of Access are you running?

 

[missinglinq via AccessMonster.com]

This is even stranger! After doing some more noodling with this problem I did
manage to reproduce it! Don't understand it, but maybe someone else here can
explain it.

When I tried to repoduce the problem using a form based on a single table, I
couldn't do so, as noted in my last post. However, when I tried the same
thing on a form based on a query pulling from multiple tables, the problem
you're experiencing did raise iit's ugly head! Most curious!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Thanks for working on this. I thought I was loosing my mind. I'll repost this
this am and see what other's think.

Rob