Search results

Cool - added to bookmarks Thanks Bob! Bird

So - a further question to help me understand this: What is the difference between Form_FrmStudentTracking!SubCourses!Date = Forms!MinCal.Value and Forms!FrmStudentTracking!SubCourses.Form.Date = Forms!MinCal.Value? Bird

You the man! Good to go!:D Gee thanks for the info on this Bob!;) As I've said before - I LOVE THIS LEARNING THING!!:p

AAAAAAAAAAAAAAARRRRRRRRRRRRRG! Took your advice and renamed all the forms/subs, now it keeps bugging out! New names Calendar FrmStudentTracking SubComments SubCourses SubReviews SubStatus "Date_subform" Forms!FrmStudentTracking!SubComments.Form.Date = Forms!Calendar.MiniCal.ValueErrors with...

Hooop - all working!! YAAAAAAY! Thanks a lot Bob - I'll try to remember your advice and NOT use spaces from now on (did say I was a noob :p). I'll be on these forums often, I think, LOL! Thanks again Bob!:D:D

Calendar - a seperate form Student Tracking - the main form 4 Subforms (all with the word 'subform' in the name): Comments subform Courses subform Reviews subform Status subform Bird

The code is from the Form_Calendar which has the MiniCal object on it. Tried changing it toForms!Student_Tracking!Comments_subform.Form.Date = Forms!Form_Calendar.MiniCal.Value but it comes up saying that it can't find the form 'Form_Calendar' Then...

OK - tried both of these Bob'sCase "Date_subform" Forms!Student_Tracking!Comments_subform.Form.Date = Me.MiniCal.Value and also Case "Date_subform" Form_Student_Tracking!Comments_subform!Date = Me.MiniCal.Value And both give me the date when I hover, but still this line is being tagged for...

Thanks for the quick response Bob, Still debugs to that line, but now hovering the mouse gives me the date that I double-clicked! I take it now, that I have to go and look at the last lines of the subform code DoCmd.OpenForm "Calendar", acNormal, , , acFormAdd, acDialog Cool - I love...

Hey all - been making a Form today with multiple subforms in - lots of feilds need dates entering, so trawled the net and bastardised various VBA code to make a single Calendar form that is activated upon double-clicking the required field. - All good to here!! Problem is that I want to be able...