Is this possible and how, any ideas?

RichGags

Registered User.
Local time
Today, 15:40
Joined
Jun 30, 2003
Messages
39
I have a Database with my customers names, party date, payment info etc....
I have a calender control on my form when I click a date, a query opens which shows me all the parties I have on that date.

Would it be possible to then be able to click a party on the query list and have thier record open on the form?

or should I do this a different way, maybe with a subform, report or another way?

Thanks.
 
Rich,

You could have an unbound combobox, or listbox, that is
populated by your query. In its AfterUpdate, or BeforeUpdate,
event you can open your form. The form will use the contents
of your control as the criteria of your recordsource.

In essence, the calander triggers the query, the query
fills your control, your control guides the form.

Wayne
 

Users who are viewing this thread

Back
Top Bottom