G
Guest
Hi. I have a set of forms for users to enter date related information. The
main data entry form works fine and I have a dialog pops up on open, search
or create new, with a calendar control to select the required date. From my
'search' or 'create new' command buttons I have everything working nicely.
However, there is one area I'm stuck. When the form first opens I want the
user to pick their date from the dialog, then use code to check if it already
exists. If it exists, I want to go to that record. If it doesn't exist, I
want to create a new record, then go to it. I can do either the going to a
record, or creating a new record just fine. The only bit I'm stuck on is
checking if the date already exists. If I can come up with a true or false
from that then a simple IF statement will lead to the correct action. Any
ideas?
Thanks (and I hope I've explained it well enough - if not please ask me to
clarify!)
main data entry form works fine and I have a dialog pops up on open, search
or create new, with a calendar control to select the required date. From my
'search' or 'create new' command buttons I have everything working nicely.
However, there is one area I'm stuck. When the form first opens I want the
user to pick their date from the dialog, then use code to check if it already
exists. If it exists, I want to go to that record. If it doesn't exist, I
want to create a new record, then go to it. I can do either the going to a
record, or creating a new record just fine. The only bit I'm stuck on is
checking if the date already exists. If I can come up with a true or false
from that then a simple IF statement will lead to the correct action. Any
ideas?
Thanks (and I hope I've explained it well enough - if not please ask me to
clarify!)