I have a search form1 with a combo box of range of age.
"Under 18
18-25
26-35
Over 35"
Once the user chooses from one of the options, another form2 should open up with all the matching ages. I've created a text field in form2 which calculates the age based on the date of birth field from the table.
I used the macro and stated if combo box of age from form1 is "Under 18" then I'm opening a new form2 and in the where clause trying to get all the records that are less than 18 years old.
My concern is that age in form2 will get calculated only once its open, so it will not work. Should I create a query and calculate age, then use that query in the where clause.
Please help me out here. I'm totally new to the macros and the coding. Thanks