Linking and populating text box between two forms

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top