Combo Box - Round Two

[M]

On an unbound form I have two combo boxes. I can get the
first one to populate by specifying the Bound Column as
the first field from a table. The second one populates
from the results of the first. Now is where I run into
problems.

When the second combo box populates, I get the appropriate
record from the table (the same table as the first). But
the user may need to change this result and have the
related record in the table update to reflect the change.
When I try to execute this action I get an error saying
that the control is already bound and can't be edited. How
can I resolve this or what would be a better way of
accomplishing this?

Thanks

M

 

[Rebecca Riordan]

When you say "change this result", do you mean choose a different record, or
edit the value that's being displayed?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...