Combo Box to display popup for custom text

[PRHoff]

Hello,


I am creating a metrics form for work Requests for Service. One of the fields is time spent, with a combo box with values from 15 minutes to more then 4 hours hours.

My question is how do I get a text box to appear to allow me to type in a custom value if more then 4 hours is selected?

Can anyone give me some help?

Thank you.

[pbaldy]

Sounds like:

http://www.baldyweb.com/ConditionalVisibility.htm

[rpeare]

depends on how your time spent field is set up, if it is a combo box and it's just a list of values you would use something like the ON EXIT property of your time spent field

if TIMESPENT = "4 or more hours" then 'You would substitute your actual text label here
  TIMESPENTEXTRA.visible = true
else
  TIMESPENTEXTRA = null
  TIMESPENTEXTRA.visible = false
endif

where TIMESPENTEXTRA is the name of your field you want to toggle visibility on. Just make sure you clear the value out if it exists already.

if your time spent is a calculated value it depends on how it's stored, if it's a decimal then it would be something like

if TIMESPENT >= 4 then 'You would substitute your actual text label here
  TIMESPENTEXTRA.visible = true
else
  TIMESPENTEXTRA = null
  TIMESPENTEXTRA.visible = false
endif

and so on, you would have to modify this if you were storing the time spent as a date/time value or if you were pulling the timespent from a table with a unique identifer and you wanted pull the text string of an unbound column you would use TIMESPENT.column(x) where x would be the 0 index based column number from your combo box (in access all list boxes/combo boxes start with column 0, so your second column is actually column(1)).

[PRHoff]

I'm getting an error message on this.
My question is, how do I set it up to be able to type in a custom value if more then 4 hours is selected in the combo box?

[pbaldy]

Getting an error on what exactly? What is the error? Where do you have the code?

[PRHoff]

Hello,
for a form measuring metrics I have a combo box stating time spent on a request for service.
It has time measurements going from 15 minutes to 4 hours. It also has a selection that says "More then 4 hours".

My question is, when I select More then 4 hours, how do I get a comment box to pop up so I can enter in the custom time.
Example: "More then 4 hours selected" (ideally comment box pops up allowing me to type in 5.5 hours and click okay)
anyone have any ideas for this?

[rpeare]

what is the rowsource of the combo box? cut and paste what's in the ROW SOURCE property. Your statement really depends on how that list is set up as noted in my first post.

[June7]

Combobox is bound to text type field?

Maybe in the combobox AfterUpdate event.

If Me.comboboxname Like "More*" Then
Me.comboboxname = InputBox("Enter elapsed time.")
End If

If you want to do calcs with this field, should be a number type and enter the same units for all records (either in minutes or decimal hours).

[pbaldy]

Threads merged since they were essentially the same topic.

[PRHoff]

row source is "15 Minutes";"30 Minutes";"45 Minutes";"1 Hour";"1.5 Hours";"2 Hours";"2.5 Hours";"3 Hours";"3.5 Hours";"4 Hours";"> 4 hours"

[rpeare]

from my original post:

if TIMESPENT = "4 or more hours" then 'You would substitute your actual text label here 
    TIMESPENTEXTRA.visible = true 
else   
    TIMESPENTEXTRA = null   
    TIMESPENTEXTRA.visible = false 
endif

You have to substitute in your actual value where you see I have "4 or more hours" and you have to insert your actual field names where I have TIMESPENT and TIMESPENTEXTRA

[June7]

Do you plan to do calculations with that data, such a Sum of the time for a group of records?