List values depending on value

[ezikeeill]

Heyo all,

Heres my situation short and sweet. I'm a teach looking to create a database for easy recording keeping for detentions. I have a school list of names and room numbers for each student in the school.

I have created a few drop down boxes so the other teachers can fill them in. Heres an example of what i'm creating.


A B C D E
1 Rm2 John Smith throwing paper 2 days detention
2 Rm7 Sally Snot no homework 1 days detention
3

So on and so forth. I've had success with creating a list from a drop down box of room numbers. What the tricky part is colum B where it must search for john's name out of a class list of names of the whole school.

Can anyone shed any light on this for me please?

Thanks,

Ezikeeill.

[DonkeyOte]

It's not very clear to me whether the names are linked to the Rooms or not ?

If so it sounds very much as though you're talking about Dependent Data Validation (ie Room selection determines Name options) - if so and you search the Forum (& Google) on this topic you will find lots of examples.

If you need more detailed help I'd suggest posting a mock up of your file - dummy student names etc to avoid confidentiality issues.

[JBeaucaire]

Data Validation lists are ill-suited to help with this problem. But using them allows you to use the sheet cells themselves to make the selections, very desirable from a simplicity standpoint.

In other words, there is no in-dropbox aid with Data Validation lists.

But the ComboBox found on the Control Toolbox has a property called MatchEntry - fmMatchEntryComplete that will autocomplete the entry as you type, making it a very attractive control to use.

The best way to employ this would be to have these Control Toolbox ComboBoxes at the top of your sheet where the choices would be made, then a SAVE button which would copy the values of these comboboxes into your data set and clear the boxes for the next entry.

Try it out, it's fun to learn. Or post up your sample workbook and we'll help get you started.