Unbound field attribute in a tabular form

[Guest]

Hello,

I have a Tabular Form on tblStatus (StatusID, Status Desc).
I added an unbound combo box to the tabular field that they can choose a
value for.

The problem is when a value is chosen it appears in ALL the occurrences
showed in the screen and not just the one they were working on.

Any idea how to fix it?

 

[Dirk Goldgar]

Hello,

I have a Tabular Form on tblStatus (StatusID, Status Desc).
I added an unbound combo box to the tabular field that they can
choose a value for.

The problem is when a value is chosen it appears in ALL the
occurrences showed in the screen and not just the one they were
working on.

Any idea how to fix it?

An unbound control on a continuous (AKA "tabular") form is really only
one control drawn multiple times, so it always shows the same value for
all records. If your intention is for the user to choose a different
value for each record, then where is that value to be stored? Normally,
it would be in the table the form is based on. If you add a field to
that table, and bind the combo box to that field, then it can show a
different value for each record.

If this is not a suitable solution for you, then please explain more
about what this combo box is for, and why it is unbound.

 

[Guest]

Thanks for the answer.

No, I did not want to store it in the table... that unbound field was
suppose to be sort of an "Action" fields (what they want to do with the
information) i.e. Reply to the message, forward the message , read the
message...

Based on what was chosen, I was going to run a module to perform it....

I found sort of a round about way, where I use buttons (they have to click
on the right action button) - but since I have limited space on the screen
(and have about 5 actions they can do), I would still like to find another
way (i.e. with an unbound field?)

Any sugguestion would be welcomed

 

[Dirk Goldgar]

Thanks for the answer.

No, I did not want to store it in the table... that unbound field was
suppose to be sort of an "Action" fields (what they want to do with
the information) i.e. Reply to the message, forward the message ,
read the message...

Based on what was chosen, I was going to run a module to perform
it....

I found sort of a round about way, where I use buttons (they have to
click on the right action button) - but since I have limited space on
the screen (and have about 5 actions they can do), I would still like
to find another way (i.e. with an unbound field?)

Any sugguestion would be welcomed

In a continuous form, any unbound control is always going to show the
same value for all records. Unless there's some mechanism -- such as a
field in the table -- to store for each record what action was chosen
for that record, I don't see how you're going to make a combo box in the
detail section work. You could put the combo box in the form header or
form footer, so there'd just be one combo box shown for all the records,
and you could then have the user click a record to make it current, then
click on the combo box and choose an action for that record. That would
be somewhat cumbersome and error-prone, though.

 

[Guest]

Yes

Well I guess we will have to stick with the buttons