I'm not sure where this question should be. I have a form (FOM) that uses a table (fom sum tbl) for it's record source. I want to create a macro or function (not at all sure how to write a function) that updates the fom sum tbl field [sponsortype] if the field [total amt] on fom sum tbl > 0 and < 25 then sponsortype = "Donation", Or if [total amt] > 24 and [total amt] < 50 then [sponsortype] = "Bronze". I know I could make several different queries that update the table but I was trying to not have to make that many queries (I have more conditions than above) and then have the macro open and close each query.
Can anyone help
THanks a bunch.