Hi,
I have a client that has an existing application written in Access.
We are attempting to port the data layer to SQL 2005 but are
experiencing a problem.
After upsizing the forms display correctly and all combo boxes can
have their values changed, but when we come to add a new record the
combos start to mis-behave. They populate their values correctly from
the database tables acting as lookups but then they don't allow you to
select any of their values for the record. When you click on a row it
just sits there.
Has anyone experienced this problem before? Do you require more
information?
Many Thanks,
Ron.
I have a client that has an existing application written in Access.
We are attempting to port the data layer to SQL 2005 but are
experiencing a problem.
After upsizing the forms display correctly and all combo boxes can
have their values changed, but when we come to add a new record the
combos start to mis-behave. They populate their values correctly from
the database tables acting as lookups but then they don't allow you to
select any of their values for the record. When you click on a row it
just sits there.
Has anyone experienced this problem before? Do you require more
information?
Many Thanks,
Ron.