Can't update subform

W.Dnx.W

Registered User.
Local time
Today, 05:51
Joined
Feb 23, 2006
Messages
51
I moved this to it's own thread since it wasn't the same question as was posed by the thread creator.
Pat

Not really the same issue but I thought to save us all from another thread...I have three subforms on a main form which are linked master/child. When I go through records on my first sub other two should be showing the additional info. I'm using requery as an form_current sub and works well with one sub, but doesn't work right with the other. The thing is that it shows the data on the form only if there is some data in the table already, but not if you want to add some new.

this is the code:
------------------
Private Sub Form_Current()
Dim ParentDocName As String

On Error Resume Next
ParentDocName = Me.Parent.Name

If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![tblInfoSub].Requery
Me.Parent![tblInfo2Sub].Requery
Me.Parent![tblKategorije subform].Requery
End If
-----------------------------------

since I am actually getting requery to work...what else might be the issue

tnx a lot

Daniel
 
Last edited by a moderator:
It seams that the second sub form had it's data property set to an SQL instead to the form that I'm using already...so now I can see it all the time...but still no editions allowed. And it's not about the allow editions property...cause even if you don't allow it, you can still set your cursor in the field, though you can't write anything. In my case, it wouldn't even make note of a click upon it...weird.
D
 

Users who are viewing this thread

Back
Top Bottom