Need VBA Codes for a Huge Problem in MS Access

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hi Folks,
I have a huge issue and i need your help.let me list the controls that
are invovled:

1.cmdAddFinding ---command button on frmSystem--> DataSource(tblSYS) to
go to frmNewFinding(LinkCriateria SYS_ID)

2.frmDialogBox --- Dialog box form apears after the user click on
cmdAddFinding
That Dialog Box has a unbound txtbox called txtCode. this text box will
take the input from the user a five alphanumeric code.
Also there a bound txtbox called txtTestBeginDate is on the
frmDialogBox which should come from txtTestBeginDate from the
frmSystem.

3. frmNewFinding has a subform called frmFindings which has a textbox
called
txtFindingNo--- Control Source-tblFinding [tblSYS has a 1 to many
relation with tblFinding]

4. when the user get to frmNewFinding, i am required to populate the
txtFindingNo with the five digit code that i took from the user
attached with the TestBeginDate and autonumber like 001.
Sample Finding Number would be [ABCDE(TestBeginDate)001]
[(FiveDigitCode)(TestBeginDate)(autmatically populated number)

5. if the user start over from the frmSystem for the same System_ID and
click cmdAddFinding, the frmDialogBox should not appear, instead the
txtFindingNo should be automatically populated with five digit code
that the user entered for the first finding and the TestBeginDate and
002 for the second finding.

6. Once the first Finding No is entered, no one should be able to
change the TestBeginDate.

I hope i have described my problem quite breifly and i am hoping
someone out there with the black belt in VBA can help me resolve this
issue.


Thanks Millions in advance

Moe
 
I forgot to add a step after step 2.

Step3. frmDialogBox has a command botton called cmdContinue. when the
user enter the five digit code and the date is already there, it lead
the user to frmNewFinding and fills the txtFindingNo with the code that
the user inputed along with the TestBeginDate and at the end 01 for the
first finding.


Thanks alot

Moe
 
Back
Top