Hi All,
I have a continuous form for entering drugs for each drug it has a combobox to select frequency (Day, Week, Month, Year) I would like the result of this field to change the label for just that record. There's a bit of vba that adds and "s" and changes the unbound text box. I did originally do it as a label but thought I could solve this issue with an unbound text box. I'd like to avoid saving the days part as a bound field as it's aesthetic.
i.e.
DrugA 3 times a Day for 3 days
DrugB 2 times a Week for 4 weeks
Problem is when I change one record I change all unbound fields for that column.
Sorry for the poor explanation, is there a way, or is it make it a bound field?
Many Thanks
Thicko
I have a continuous form for entering drugs for each drug it has a combobox to select frequency (Day, Week, Month, Year) I would like the result of this field to change the label for just that record. There's a bit of vba that adds and "s" and changes the unbound text box. I did originally do it as a label but thought I could solve this issue with an unbound text box. I'd like to avoid saving the days part as a bound field as it's aesthetic.
i.e.
DrugA 3 times a Day for 3 days
DrugB 2 times a Week for 4 weeks
Problem is when I change one record I change all unbound fields for that column.
Sorry for the poor explanation, is there a way, or is it make it a bound field?
Many Thanks
Thicko