LPurvis
AWF VIP
- Local time
- Today, 19:35
- Joined
- Jun 16, 2008
- Messages
- 1,269
You're welcome - I'm glad you're getting it.
Though I would appreciate it if you didn't sit up all night delving ever deeper into the nuances of Access.... That's my job.
It should be simple once you see what's happening (and would have perhaps been simpler had their been only one example in the MDB and dedicated querydefs had been created for each task).
But ultimately as long as you see the two processes in play - one to initially limit the listbox and the second to limit the form results based on the listbox selection - then it's standard stuff.
(Bearing in mind what I mentioned about the need to use a hidden control for the first part to respond as the user types. And to answer your "virtual" question - yes it would be possible to do all this source assignment in VBA. It just isn't necessary - parameter queries are equally there for a reason ;-)
Cheers!
Though I would appreciate it if you didn't sit up all night delving ever deeper into the nuances of Access.... That's my job.
It should be simple once you see what's happening (and would have perhaps been simpler had their been only one example in the MDB and dedicated querydefs had been created for each task).
But ultimately as long as you see the two processes in play - one to initially limit the listbox and the second to limit the form results based on the listbox selection - then it's standard stuff.
(Bearing in mind what I mentioned about the need to use a hidden control for the first part to respond as the user types. And to answer your "virtual" question - yes it would be possible to do all this source assignment in VBA. It just isn't necessary - parameter queries are equally there for a reason ;-)
Cheers!
