Not sure ! (1 Viewer)

[anthonyphillips]

Hi Guys

Can anybody help?

I am trying to put together a database for my organisation and i want the data entry form to work in a way that if yes is entered into a box then a new box will appear on the screen to allow supporting evidence to the yes answer, if a no is entered then the evidence box does not appear.

I know this is possible as I have seen it in use, granted they have been on webpages so I am hoping its possible in Access.

Thanks in advance

Anthony

 

[JamesMcS]

Use a combo box with yes and no as its value list. In the afterupdate of the combo box put something like "if combobox.value = "Yes" then text box.visible=true, else textbox.visivle=false"