I am back on this issue again. This seems to work fine with linking the units to there projects. But I also need to link Units to Unit Improvement but it keeps giving me a error:
I added a txtUnitID to my mainform but it bombs when I try setting the parent child relationship to txtUnitID and UnitID. I think it because it does not exist yet and I am not sure how to get around it.
I have uploaded to the Needs Assistanct folder. Please look at and show me what the heck I am doing wrong.
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Saturday, May 14, 2011 2:03 PM
Subject: RE: [MS_AccessPros] Passing ID from subform to subform
Art,
I typically have an invisible text box on the main form named "txtProjectID". I set the link master/child of the sfrmUnitList subform to txtProjectID and ProjectID. Then add code to the On Current of the sfrmProjectList to:
Me.Parent.txtProjectID = Me.ProjectID.
This will synchronize the subforms.
Duane Hookom
MS Access MVP
From: dbalorenzini@yahoo.com
I have a form called frmProjectUnit. On this form are two subforms called sfrmProjectList (visible=true) and sfrmUnitList (visible = false) respectively.Both of the subforms are continous forms type.
On the frmProjectUnits there are multiple command button but the ones I have an issue is with cmdProjectUnits and cmdProjectInfo.
The functionality is that the user will select one of the records off of the sfrmProjectList and then click cmdProjectInfor to open the frmProjectDetails for to the correct record based on the selected projectID. This part works.
When the user click on the sfrmProjectlist row the ProjectID is moved to a global variable called mlngProjectID. What I am trying to get to work is once the user click on the specific Project they want and then click the cmdProjectUnits the sfrmUnitList should display with the correctly filtered Units based on the projectID contained in mlngProjectID.
I hope that makes sense.
Thanks you
Art
Sioux falls,SD
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar