A
Alex Hammerstein
Hi
I have used this following code in access 2003 and it works perfectly.
However I am trying to use in Access 2007, which I have just started to use,
and get and error message: Object doesn't support this object of method.
Has it been changed in 2007?
Thanks
Code used:
If Nz(Me![cboSelector], "") <> "" Then
Select Case Left(Me![cboSelector].Column(1), 3)
Case "qry"
Me![EditingPanel].SourceObject = "query." &
Me![cboSelector].Column(1)
Case "tbl"
Me![EditingPanel].SourceObject = "table." &
Me![cboSelector].Column(1)
Case "frm"
Me![EditingPanel].SourceObject = Me![cboSelector].Column(1)
End Select
End If
I have used this following code in access 2003 and it works perfectly.
However I am trying to use in Access 2007, which I have just started to use,
and get and error message: Object doesn't support this object of method.
Has it been changed in 2007?
Thanks
Code used:
If Nz(Me![cboSelector], "") <> "" Then
Select Case Left(Me![cboSelector].Column(1), 3)
Case "qry"
Me![EditingPanel].SourceObject = "query." &
Me![cboSelector].Column(1)
Case "tbl"
Me![EditingPanel].SourceObject = "table." &
Me![cboSelector].Column(1)
Case "frm"
Me![EditingPanel].SourceObject = Me![cboSelector].Column(1)
End Select
End If