It sounds like you can get as far as entering the times... As far as calculating the time between, you could do this:
Create a query against the table that contains the numbers selected in the form. Then combine the numbers like this:
=[txtHour] & ":" & [txtMinute]
Then you can format that...
You should be able to create your combo box to pull the information you need, then open the form based on the value selected in the combo box.
A good way to do this is to create a command button with the wizard. Create the command button and select Open Form, then select the form to open. On...
If you use:
For one, the ControlSource is: =Now() and the Format is: hh:nn:ss
For the other, the ControlSource is: =Date() and the Format is: Long Date
Won't this just display the date/time that you opened the form?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.