Help with calendar function

[Guest]

I am trying to build a daily schedule with a calendar control.

What I have so far is a table 'tblSchedule' with the following fields:

DateID : autonumber
schDate : Short date format
0830 : text
0900 : text
etc...

On my form 'frmSchedule' I have a popup calendar that the user selects the
date from.

In the 'frmSchedule' textboxes '0830timeslot' etc... is a conditional
DLookup based on the value of hidden textbox '0830'

I would like to be able to select a date from the popup calendar, and IF the
date already exists in the 'tblSchedule', populate the hidden textboxes with
the value for each.

If the date does not exist, open the form and create a new record in the
'tblSchedule'.

I can't use a conditional statement for the hidden textboxes that would
match the date, because double clicking in the matching timeslot opens a form
which the user selects a name from and when done, it inserts the nameID value
into the hidden textbox thus updating the tblSchedule.

Can someone point me in the right direction?

Thanks.

 

[PC Datasheet]

Paul,

Send me your email address to my email address below and I will send you a
screenshot of a scheduling module I have.