Passing data between forms Access 2000

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

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 said:
Answered under other post subject "hi"

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

Abay said:
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
Click to expand...
Click to expand...
 
Back
Top