Unbound Column Should Contain Certain Value For Each Record

[ahd2008]

Hi,

I've a query on a tabular form the represents the cureent status of the availabe seats of each course. I added unbound column(Status) to the form that supposed to say either close when the number of the availabe seats is =0 or open when the number of the avaialbe seats is >0.

Can this be applied on tabular forms? If not is there substitute approach?

[missinglinq]

The value of an Unbound control on one record is the value of that control on all records. In a Single View form you can use code in the Form_Current event set the field based on something, such as available seats, but this doesn't work in Datasheet or Continuous View forms

You'll have to bind the Status field to your underlying table for it to reflect that particular record/class' status.

Linq ;0)>

[NeoPa]

The standard way to handle this, as Linq indicates, is to add a calculated column to your query and bind the control on the form to that.

FYI: Why Values in Unbound Form Controls do not Persist may help you to understand why this is the way to do it.

[ahd2008]

thanks gents for your feedback

[NeoPa]

You're welcome :)