Continous Form vba changing label (1 Viewer)

[Thicko]

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

 

[theDBguy]

Hi. You should be able to use a calculated column in your query for the form. No VBA is necessary.

 

[Thicko]

Many Thanks theDBGuy,

All sorted, should have thought of that!

 

[theDBguy]

Many Thanks theDBGuy,

All sorted, should have thought of that!

Hi. You're welcome. That's what we're here for. Good luck with your project.