By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

Referencing Subforms

P: n/a
Hi everyone.

I have designed a form 'frmPeople' with a subform 'fsubPeopleList'

This form works fine on it's own but when used as a subform on a main menu
it doesn't work.

The code in question is as below and the line causing the problem has the *
to the right of the text.

Can anyone see what I'm doing wrong please.

Thanks in Advance,

John
>>>>>>>>>>>>>>>>>>>>
Option Compare Database
Option Explicit

Private Sub Form_Current()

Dim theRecord As String
If Me.CurrentRecord <Me.Parent.CurrentRecord Then
theRecord = Me.CurrentRecord
DoCmd.GoToRecord acDataForm, Parent.Name, acGoTo, theRecord *
Me.Parent.strSearch.SetFocus
End If

End Sub
Oct 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Found my own reply thankfully:

"Access won't let you have a subform within a subform if the data has to be
displayed in a continuous form."

taken from:
http://msdn.microsoft.com/library/de...tml/sa03c1.asp
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"John Ortt" <jo******@noemailsuppliedasdontwantspam.comwrote in message
news:45**********@glkas0286.greenlnk.net...
Hi everyone.

I have designed a form 'frmPeople' with a subform 'fsubPeopleList'

This form works fine on it's own but when used as a subform on a main menu
it doesn't work.

The code in question is as below and the line causing the problem has the
* to the right of the text.

Can anyone see what I'm doing wrong please.

Thanks in Advance,

John
>>>>>>>>>>>>>>>>>>>>>

Option Compare Database
Option Explicit

Private Sub Form_Current()

Dim theRecord As String
If Me.CurrentRecord <Me.Parent.CurrentRecord Then
theRecord = Me.CurrentRecord
DoCmd.GoToRecord acDataForm, Parent.Name, acGoTo, theRecord *
Me.Parent.strSearch.SetFocus
End If

End Sub

Oct 26 '06 #2

P: n/a
No I haven't,

The previous posting refers to using continuous forms at the top level which
I am not doing.

Oh well, any ideas?
"John Ortt" <jo******@noemailsuppliedasdontwantspam.comwrote in message
news:45**********@glkas0286.greenlnk.net...
Found my own reply thankfully:

"Access won't let you have a subform within a subform if the data has to
be displayed in a continuous form."

taken from:
http://msdn.microsoft.com/library/de...tml/sa03c1.asp
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

"John Ortt" <jo******@noemailsuppliedasdontwantspam.comwrote in message
news:45**********@glkas0286.greenlnk.net...
>Hi everyone.

I have designed a form 'frmPeople' with a subform 'fsubPeopleList'

This form works fine on it's own but when used as a subform on a main
menu it doesn't work.

The code in question is as below and the line causing the problem has the
* to the right of the text.

Can anyone see what I'm doing wrong please.

Thanks in Advance,

John
>>>>>>>>>>>>>>>>>>>>>>

Option Compare Database
Option Explicit

Private Sub Form_Current()

Dim theRecord As String
If Me.CurrentRecord <Me.Parent.CurrentRecord Then
theRecord = Me.CurrentRecord
DoCmd.GoToRecord acDataForm, Parent.Name, acGoTo, theRecord *
Me.Parent.strSearch.SetFocus
End If

End Sub


Oct 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.