Dropdowns And Dims

[Irwin109]

It's me, again! It's like the madness never ends!

I have two problems this time.

1. I have a dropdown box of names linked to a subform built off a query.
What I want it to do is lookup the selected name [Carer] and find the
relevant records, but instead it's just changing the name [Carer] for the
first record.
The records in the subform are [Carer Name] [Client] [Times].

2. I want to know if there is a way to reference/call/fetch a dim from
outside of the sub that requires it.

I can explain in more detail if required.

 

[Keith Wilby]

It's me, again! It's like the madness never ends!

I have two problems this time.

1. I have a dropdown box of names linked to a subform built off a query.
What I want it to do is lookup the selected name [Carer] and find the
relevant records, but instead it's just changing the name [Carer] for the
first record.
The records in the subform are [Carer Name] [Client] [Times].

2. I want to know if there is a way to reference/call/fetch a dim from
outside of the sub that requires it.

I can explain in more detail if required.

You need to use an unbound combo box with a query on Carer's name as the row
source and some code in its After Update event to return the relevant
records based on the user selection.

Post back if you need more detail.

Keith.
www.keithwilby.co.uk