Ok .. here you go. I like continuous forms. They look pretty mostly is why I like them.
But .. issues as using unbound controls are not that much fun and I am pretty limited.
Here is my issue .. I have a form as below and I use Datepart("h",[TransTime]) to get the hour which I then use for the actual number of transmissions in that hour. (This is for a radio system). Pretty straight forward stuff .. but I wanted to display the actual time on the form.
So .. hour 14 would be "2:00:00 PM - 2:59:59 PM". I did get it to work as you can see .. but is there an easier way ?
I tried a recordset clone .. and making the value of my unbound text box based on the bound hour number field. But .. I always got the same values .. in this case, the last one "11:00:00 PM - 11:59:59 PM" for all of my 24 records on the form.
What I did .. is make a lookup table with the hour and timetext in it. So .. 14 as a number field and the text as above. I made a query to link up the transmission counts / hours with this time value from this lookup table. I understand that on a continuous form .. your query control source must contain the data for your fields ? unless of course you want to overly complicate things.
I just want to get away from the lookup table .. it works. But .. is it so hard to use an unbound control on a continuous form ?
Below is the end result .. it works, I just want to learn if there is a better way.