access-guru? wrote:
Once you detect the query change, trigger a sub with the following
code:
Me.RecordSource = "Query_Name"
This will refresh the form
Thanks, but I get an error message
runtime error '438
object doesn't support this property or method
I have a master form called 'Hall Bookings from Calendar'
inside this I have a subform called 'Sidebar'
Perhaps a picture is better...
__________________________________________________ _____________________________
Form_Hall Bookings from Calendar
__________________________________________________ _____________________________
______________________
Subform_Sidebar | Date:
| Name:
P Dec 31 New years | No Guests:
R Jan 5 Wedding | Many other fields:
R Jan 7 Meeting |
______________________|
______________________
Listbox |
|
Riverside |
Palace |
|
_______________________
__________________________________________________ _______________________________
So when they click on Riverside in the listbox, the Query that is the
recordsource for sidebar is changed to restrict the listing to only R
events.
Clicking on an individual event in the sidebar causes the fields on the
form to reflect that event.
Everything is working, except the update to the sidebar. If I close the
form and reopen it, it reflects the changed query.
Thanks for any help you can give
Lester.