Dropdowns And Dims

  • Thread starter Thread starter Irwin109
  • Start date Start date
I

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.
 
Irwin109 said:
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.
Click to expand...

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
 
Back
Top