calculate field based on second column of selection

[papasmurfuo9]

Hi

i have a form, where one field is a combo box

the combo box is two columns linked to at table,
task and sla

you pick the task, and it displays the task

what i need is, another field, to equal the SLA part of that task

make sense?

thanks in advance

 

[Christos99]

You can refer to the currently selected values in the combo box using the column property.
So cboname.column(0) is the first and cboname.column(1) is the second.
Is that what you are asking ?

 

[papasmurfuo9]

Hi
thanks for the reply

yes

so in my field which i need to reference to the second column in the combo box

what do i put?

 

[Christos99]

Have a text box on the form.
Set it's control Source property to =Combo0.column(1) where combo0 is your combo box name. This will update on the form when you change the combo box selection.

 

[papasmurfuo9]

thank you

could you tell me how to do the below, but use weekdays?

=Now()+[Txt_Category].[column](1)

 

[Christos99]

Use & to concatenate 2 strings.

=Now() & [Txt_Category].[column](1)

Try looking up help on Weekday function