Auto Fill? help me please!!

[greyskyeyes]

In using a form to input new information, I want to utilize the autofill feature, but I don't know how.

For example. When someone inputs a month, I want the season to be automatically entered in, in the following entry.

Can someone please give me some direction or help me to do this!?

Thanks!

 

[llkhoutx]

Create a table on Months and Seasons, e.g.

tblSeasons
iMonth sSeason
1 Winter
2 Winter
etc.

On your form create a combobox, called sSeason (coincidently named) which has the above table as its Row Source and a Control Source of iMonth. tblSeasons is linked to the table/query which is the record source for your form with iMonth is also part of the forms record source.