Hello,

I have a master/detail form with a button which when clicked displays 
summary data line by line in a different form, which contains a "More" 
button which when pressed should display a copy of the Master/detail form 
with all the data.  I have done this in another data bases (Access 98 & 
2003) with no problems, but I now get no data passed back when the "More" 
button is pressed.

My code is as follows:

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "FClient_and_sub_more"

    stLinkCriteria = "[Cname]=" & "'" & Me![Cname] & "'"

       DoCmd.OpenForm stDocName, , , stLinkCriteria

"Cname" is the key on the Master/detail form and it is present on the 
Summary form.  For some reason I think it is blank .. don't know how to see 
its value when the code is executing, my knowledge of access code is very 
limited.

Any help would be much appreciated.

Abay

Answered under other post subject "hi"

Please do not multipost, as it's confusing...
-- 
hth,
SusanV

"Abay" <abcd@aol.com> wrote in message 
news:ump8G68hHHA.5048@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> I have a master/detail form with a button which when clicked displays 
> summary data line by line in a different form, which contains a "More" 
> button which when pressed should display a copy of the Master/detail form 
> with all the data.  I have done this in another data bases (Access 98 & 
> 2003) with no problems, but I now get no data passed back when the "More" 
> button is pressed.
>
> My code is as follows:
>
>    Dim stDocName As String
>    Dim stLinkCriteria As String
>
>    stDocName = "FClient_and_sub_more"
>
>    stLinkCriteria = "[Cname]=" & "'" & Me![Cname] & "'"
>
>       DoCmd.OpenForm stDocName, , , stLinkCriteria
>
> "Cname" is the key on the Master/detail form and it is present on the 
> Summary form.  For some reason I think it is blank .. don't know how to 
> see its value when the code is executing, my knowledge of access code is 
> very limited.
>
> Any help would be much appreciated.
>
> Abay
>
>
>
>
>
>
>
>
> 

Hello  ... there's some sort of mix up here .. apologies, I know  to only 
post once & thought I had . not sure what happened .. thanks for pointing it 
out, also many thanks you for your help on the problem , will do as you say.

Abay


"SusanV" <svanallen@nospam-mvps.org> wrote in message 
news:OtzAne$hHHA.4552@TK2MSFTNGP04.phx.gbl...
> Answered under other post subject "hi"
>
> Please do not multipost, as it's confusing...
> -- 
> hth,
> SusanV
>
> "Abay" <abcd@aol.com> wrote in message 
> news:ump8G68hHHA.5048@TK2MSFTNGP03.phx.gbl...
>> Hello,
>>
>> I have a master/detail form with a button which when clicked displays 
>> summary data line by line in a different form, which contains a "More" 
>> button which when pressed should display a copy of the Master/detail form 
>> with all the data.  I have done this in another data bases (Access 98 & 
>> 2003) with no problems, but I now get no data passed back when the "More" 
>> button is pressed.
>>
>> My code is as follows:
>>
>>    Dim stDocName As String
>>    Dim stLinkCriteria As String
>>
>>    stDocName = "FClient_and_sub_more"
>>
>>    stLinkCriteria = "[Cname]=" & "'" & Me![Cname] & "'"
>>
>>       DoCmd.OpenForm stDocName, , , stLinkCriteria
>>
>> "Cname" is the key on the Master/detail form and it is present on the 
>> Summary form.  For some reason I think it is blank .. don't know how to 
>> see its value when the code is executing, my knowledge of access code is 
>> very limited.
>>
>> Any help would be much appreciated.
>>
>> Abay
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>