[mso] Access VB Code
- From: "April Pace" <4office@xxxxxxxxxxxxx>
- To: "Office (E-mail)" <mso@xxxxxxxxxxxxx>
- Date: Fri, 3 Jan 2003 15:17:03 -0500
Ok I got this code to Work:
Private Sub cbxCltRespon_AfterUpdate()
If Me.cbxCltRespon.Value = True Then
Me.txtCltResponName.Value = Null
DoCmd.OpenForm "sfrmContactResponParty"
Else
txtCltResponName = [txtCltFName] & " " & [txtCltLName]
End If
End Sub
The part about Me.txtCltResponName.Value=Null is there in case they want to
change the Responsible Party from the Client and make it somebody else... So
if at some time in the past it had populated the txtCltResponName with the
Client Name it will delete it.
Now when It (leaving this Form frmClientInfo open) opens the
sfrmContactResponParty form and the user fills it out... there is a
corresponding field txtCltResponName.... When the user closes the
sfrmContactResponParty Form I want what ever name they put on that Form in
the txtCltResponName field... I want it to automatically populate the main
form frmclientInfo form (Changing what's there if anything)
Do I need to mention that on this form this is a primary/foreign Key combo
of nbrCltID and txtCltConResID
April
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
