M
Mike Green
Hi all
I have a continuous form called FmDeliverysheet, with a date field called
FdDDate. At the moment when the user clicks in the FdDDate record and I
have used an Event Procedure to make the Calendar visible which I have
embedded in the form. There is some checking to see if there is a date in
the field, if so the calendar displays that date, if not the calendar
displays today's date. When the user clicks on the date in the calendar the
calendar disappears and the date that was clicked is populated to FdDDate.
I am trying to write the code to open the calendar in a new form called
FmDateSelect and use the same logic that I have just described that is:-
User clicks FmDeliverysheet.FdDDate and the Form.FmDateSelect opens
If FmDeliverySheet.FdDDate has a value then FmDateSelect Should display that
date.
If there is no date in the cell FdDDate then FmDateSelect should display
today's date
When the user clicks on a date in the calendar embedded in the
Form.FmDateSelect the date click is entered into the FdDDate in the
FMDeliverysheet.
My problem is that because the FmDeliverysheet is a continuous form I cannot
get the date to appear in the correct record (the one that was click to
start the sequence, it is not necessarily the last record in the sheet) Can
some one please help or tell me that I am doing it all wrong and suggest a
cleaner way of doing this. please please your help will stop me going
insane!
Thanks in advance
Mike
I have a continuous form called FmDeliverysheet, with a date field called
FdDDate. At the moment when the user clicks in the FdDDate record and I
have used an Event Procedure to make the Calendar visible which I have
embedded in the form. There is some checking to see if there is a date in
the field, if so the calendar displays that date, if not the calendar
displays today's date. When the user clicks on the date in the calendar the
calendar disappears and the date that was clicked is populated to FdDDate.
I am trying to write the code to open the calendar in a new form called
FmDateSelect and use the same logic that I have just described that is:-
User clicks FmDeliverysheet.FdDDate and the Form.FmDateSelect opens
If FmDeliverySheet.FdDDate has a value then FmDateSelect Should display that
date.
If there is no date in the cell FdDDate then FmDateSelect should display
today's date
When the user clicks on a date in the calendar embedded in the
Form.FmDateSelect the date click is entered into the FdDDate in the
FMDeliverysheet.
My problem is that because the FmDeliverysheet is a continuous form I cannot
get the date to appear in the correct record (the one that was click to
start the sequence, it is not necessarily the last record in the sheet) Can
some one please help or tell me that I am doing it all wrong and suggest a
cleaner way of doing this. please please your help will stop me going
insane!
Thanks in advance
Mike