combobox on a report

[klr397]

I have a report which looks up candidates by skill and there are six skills, now i need to use a second list of 6 combo boxes that will be tied to each skill that will pull up the last date used. the user will ener a skill from the skill combo box and then type in a year that they want the skill to have been last used on or higher.

-do i use a combo box if they are going to be typing in the year?
- how do i tie each skill to eac seperate last date used.

i attempted to create a new combo box and have it pull the information from the candidate skilltable for the list of last years but it shows up empty. If anyone knows how to help i would greatly appreciate it. if any code isneeded i could provide that as well

thank you thank you thank you

 

[lawsonium]

To expand on this post (sorry to hijack you here). Can anyone tell me how you can use a combobox on a report to alter the output of the report.

e.g. select a new value in the combobox and refresh the form usnig the new value selection.

Thanks,

Matt.

 

[GaryPanic]

Matt .

2 different problems - yours is easy
on a combo box normally you have a reference number and a name (not always)

now on the on click propeties and after update propeteris you can then use
if combobox.column(0) (access stars counting from 0) = 1 do x
if combobox.column(0) (access stars counting from 0) = 2 do Y
if combobox.column(0) (access stars counting from 0) = 3 do z



you get the idea
now you need a refresh in here as well as well as a save