G
Guest
I have searched and read responses on my topic but want to ask for a bit more
detail.
My database has a personnel form that has an authorizations subform. Their
may be numerous authorization records for a particular person. I want the
sorted in a custom order such as TRAINED AND AUTHORIZED, ONE-TIME, CANCELLED,
TRAINING REQUIRED.
I followed the help file and created a small query that, using the SWITCH
function assigns a numerical value to my text value, then sorts on the
numeric. Thing is I can't figure out how to apply it to my form. Do I need to
make this query the entire record source for the form? I am concerned with
this as I don't really like using query based forms to update data. Or is
this much ado about nothing?
Thanks
detail.
My database has a personnel form that has an authorizations subform. Their
may be numerous authorization records for a particular person. I want the
sorted in a custom order such as TRAINED AND AUTHORIZED, ONE-TIME, CANCELLED,
TRAINING REQUIRED.
I followed the help file and created a small query that, using the SWITCH
function assigns a numerical value to my text value, then sorts on the
numeric. Thing is I can't figure out how to apply it to my form. Do I need to
make this query the entire record source for the form? I am concerned with
this as I don't really like using query based forms to update data. Or is
this much ado about nothing?
Thanks