Auto-filling in a Form

[luveska]

Hello,

I am a novice Access 2010 user (I've taken a couple half-day seminars through work) and I've taken on the task of creating a database for my area.

What I am try to do is insert an auto-fill into one of my forms.

I want to select a school from a drop-down list, and have the corresponding School Board auto-populate. I have a table in my database that lists Schools and their corresponding School Board called "Schools".

The Form I am using, which we can call, "Modifications", is based off the "Modifications table" and an "Invoices" sub-table.

Can anyone step by step help me to insert an auto-fill so I don't have to manually select the school board every time?

If you need screenshots or any additional info, please let me know.

Thanks

 

[pbaldy]

Is this appropriate?

http://www.baldyweb.com/Autofill.htm

 

[luveska]

To someone with a bit more experience with the program, I'm sure it is more than sufficient, but I haven't a clue where to begin/where to enter things.