I am trying to;
Click on a textbox in a form called frmcalendar to open another form
petalplanning
(I can do that bit). However I want the form to open at a certain
record depending on the date in a textbox (called date8) on
frmcalendar. (Eg date8 in frmcalendar is to match the date in the
record called plandate in the petalplanning form)
I thought i would be able to do it this way but my criteria is wrong
DoCmd.OpenForm (petalplanning,acNormal, ,"plandate =
Forms!frmCalendar!date8")
Any suggestions how I can correct this? Thanks