theinviter
Registered User.
- Local time
- Today, 16:35
- Joined
- Aug 14, 2014
- Messages
- 237
Hi Guys;
nee help
i have created a form and when i select from drop list the item name the exp date field will be updated based on the number with each drop list but if the number is null i got error " Type Mismatch",
the code is:
Private Sub Name_AfterUpdate()
BUD = name.Column(3)
exp_date = Date + BUD
End Sub
i wanna if the number is null then Exp. date will be only current date.
please advise me how to resolve this issue
nee help
i have created a form and when i select from drop list the item name the exp date field will be updated based on the number with each drop list but if the number is null i got error " Type Mismatch",
the code is:
Private Sub Name_AfterUpdate()
BUD = name.Column(3)
exp_date = Date + BUD
End Sub
i wanna if the number is null then Exp. date will be only current date.
please advise me how to resolve this issue