A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Passing data between forms Access 2000



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2007, 07:46 AM posted to microsoft.public.access.forms
Abay
external usenet poster
 
Posts: 112
Default Passing data between forms Access 2000

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









  #2  
Old April 26th, 2007, 12:40 PM posted to microsoft.public.access.forms
SusanV
external usenet poster
 
Posts: 399
Default Passing data between forms Access 2000

Answered under other post subject "hi"

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

"Abay" wrote in message
...
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











  #3  
Old April 27th, 2007, 03:28 AM posted to microsoft.public.access.forms
Abay
external usenet poster
 
Posts: 112
Default Passing data between forms Access 2000

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" wrote in message
...
Answered under other post subject "hi"

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

"Abay" wrote in message
...
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













 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.