Calendar to Query to Form?

[RichGags]

I have a database with Customers (weddings). I have their names and dates, charges payments etc...

Now, I have a form with a calendar on it. When I double click a date on the calendar it invokes a query which gives me a list of all the weddings I have on that day (just thier name and location of the party).

So, Is it possible then to double click thier name on the query and bring me to thier record on the form??

or should I do it another way? Thanks.

 

[Robert Dunstan]

Just to throw another idea into the pot...

Why not have a form with 2 subforms. On the main form place your calendar and when you select the date set the record source of the first subform to your query. Then in the second subform you can display the whole details by selecting the record in the 1st subform.