Using two fields in a table to to populate a third field

[Tawny]

Hi,

I am very new to access and I am trying to create a database/ registration form for a charity boxing match.
I would like to enter the gender (which i have created a list box for male or female) and the weight, and based upon those entries have access automatically populate the weight class field. Is this possible?

Thanks,
Tawny

[June7]

Yes, requires VBA code. Can use DLookup function in an event procedure. The trick is figuring out which event to use. Alternative is to not save the class but to do the lookup whenever needed.