F
FA
Hi Freinds,
I have the following problem:
There is a command botton of frmSystem (tblSYS_INFO)
it opens frmCalculateFindingNo which has (txtCode-- unboundtextbox,
txtTest_Begin_Date--bound and linked textbox with tblSYS_INFO
(frmSystem)), and cmdContinue). it ask the user to enter the code in
the text box txtCode
When the user click on cmdContinue, it opens frmNewFindings
(tbleSTD_FINDG) that has a control txtFindingNo
(=Forms!frmCalculateFindingNo!txtCode).
The linkCritaria is stLinkCriteria =
"[Forms]![frmNewFindings]![FINDG_NO]=" & Me![txtCode]
frmNewFindings also has a subform called frmFindings (tblFindings).
This subform has a txtbox called txtFindingNo. (txtFindingNo on Master
form frmNewFindings is linked to Child form frmFindings)
I also have a txtbox txtTestBeginDate on frmNewFinding
(=Forms!frmCalculateFindingNo!txtTestBeginDate).
when the user click on cmdContinue on frmCalculateFindingNo it opens
the frmNewFindings and populating the txtFindingNo in the subform
frmFindings.
I also want to populate txtTestBeginDate in the txtFindingNo next to
txtCode in the subform frmFindings.
So if the user enter the code ABCDE and the TestBeginDate is
01/02/2006.
So the sample txtFindingNo would look like (txtCodetxtTestBeginDate)
for example
(ABCDE01/02/2006).
How can i achieve this? please help me folks..
Thanks
Moe
I have the following problem:
There is a command botton of frmSystem (tblSYS_INFO)
it opens frmCalculateFindingNo which has (txtCode-- unboundtextbox,
txtTest_Begin_Date--bound and linked textbox with tblSYS_INFO
(frmSystem)), and cmdContinue). it ask the user to enter the code in
the text box txtCode
When the user click on cmdContinue, it opens frmNewFindings
(tbleSTD_FINDG) that has a control txtFindingNo
(=Forms!frmCalculateFindingNo!txtCode).
The linkCritaria is stLinkCriteria =
"[Forms]![frmNewFindings]![FINDG_NO]=" & Me![txtCode]
frmNewFindings also has a subform called frmFindings (tblFindings).
This subform has a txtbox called txtFindingNo. (txtFindingNo on Master
form frmNewFindings is linked to Child form frmFindings)
I also have a txtbox txtTestBeginDate on frmNewFinding
(=Forms!frmCalculateFindingNo!txtTestBeginDate).
when the user click on cmdContinue on frmCalculateFindingNo it opens
the frmNewFindings and populating the txtFindingNo in the subform
frmFindings.
I also want to populate txtTestBeginDate in the txtFindingNo next to
txtCode in the subform frmFindings.
So if the user enter the code ABCDE and the TestBeginDate is
01/02/2006.
So the sample txtFindingNo would look like (txtCodetxtTestBeginDate)
for example
(ABCDE01/02/2006).
How can i achieve this? please help me folks..
Thanks
Moe