calling dates from text boxes

[CoachPhil]

Hi all,

Answer is probably right in front of me but I have been looking at this so long I am brain dead!

I am connecting to Outlook from my DB, setting a 'reminder date', I have the following code in the cmd button,

Set objRecurPattern = .GetRecurrencePattern
With objRecurPattern .RecurrenceType = olRecursWeekly .Interval = 1 .PatternStartDate = "Text30" .PatternEndDate = "Text42" End WithI end up with an Error 113What could I be missing?CoachPhil

 

[CoachPhil]

Would this do it?

.PatternStartDate = "#Text30#"
.PatternEndDate = "#Text42#"