cant edit a specific text box on subform

leanpilar

Registered User.
Local time
Today, 02:56
Joined
Aug 13, 2015
Messages
94
HI.
I have a strange problem, I can't edit one bound field on my subfofm.
I have a code that the guest user on load set this subform allowedits on false.
but other user can edit all the others but not this field
proprieties of the fild in subform is enabled yes locked no same as is in the source form where I can edit
I try to delete this field and enter again the existing field but the problem persist.
on subform the on that field appear a 0 but the default value is empty but in the source form not.
I had a search for allowedits and the name of the filed in the code of both class module but without success.
any idea what I can check?
 
UPDATE:
in immediate windows:
me.allowedits = true
after this code it works everything
I put this code after the code to open this form ant it work for 1 sec then freeze again
I have only one code on timer for automatic logout but there are nothing about this form
 
how many secs does your timer fires, create a breakpoint there maybe you will discover something.
 
every 1000ms for time show in text field

Code:
Me.Text26.Requery 'for time
Static exittext As Integer
Static intCount As Integer
Static exittext2 As Integer
If Nz(Me.textlogout.Value) = False Then
Exit Sub
Else
Dim intexit As Integer
intexit = Me.textlogout.Value
intCount = intCount + 1
If intCount = 1 Then exittext2 = intexit
If exittext2 <> intexit Then
intCount = 0
exittext = 0
End If
If intCount > intexit - 60 Then
exittext = exittext + 1
Me.Textlogoutintxt.Visible = True
Me.Textlogoutintxt.Value = "exit in:"
Me.textlogoutin.Visible = True
Me.textlogoutin.Value = 60 - exittext
Else
Me.Textlogoutintxt.Visible = False
Me.textlogoutin.Visible = False
End If
If intCount = exittext Then
Dim intIndex As Integer
For intIndex = Forms.Count - 1 To 0 Step -1
DoCmd.Close acForm, Forms(intIndex).name, acSaveYes
Next intIndex
DoCmd.OpenForm "login"
End If
End If
this is the code triggered on hidden form
nothing about datume form and subform or frmfirst which are not allowedits
I put me.allowedits = form on load event and nothing change after 1 sec
but after click one cmdbutton with the same code everything work...
 
noway... I try to open access with shift to avoid startup and open only this form where on load event I have me.allowedits = true but after 1 sec it become blocked again and only 1 time because on button me.allowedits = true work permanently...
 
I think I found... I removed one sub form:
Maps that contain 1 text box and one web browser....
how or why because that forum has not even a class module before I change from sub form to popup and put the close button
lol?? or cry??
 

Users who are viewing this thread

Back
Top Bottom