Combo Box Problems,......HELP!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are a number of combo drop on a main (parent) form. The property setting for each drop down is set to limit to list = true. However, when the end user accesses to drop down, they are able to change the underlying table's data.

The table's values are:

A - Day
B - Day
C - Night
D - Night

After accessing the drop down combo boxes (forward typing) the user can change the value to:

B - Day
B - Day
D - Night
C - Night

Without any prompts alerting the user of the changed data potential. These, table are not part of the query behind the main form. The table(s) being used as a row source are lookup tables, used to only plug in the foreign key value in the form(s) main table. Could it be that, since it's not a different value (i.e. E, F, G, H) that the changes take place? It should not, correct?

Any idea on resolving this matter will be welcome!
 
Syd,

Although I'm not very clear on the whole picture, I suspect your combos are
not unbound, as they should be (control source > nothing), thus the changes
in the tables. Make sure you make them unbound and see if the problem goes
away.

HTH,
Nikos

Syd said:
There are a number of combo drop on a main (parent) form. The property
Click to expand...
setting for each drop down is set to limit to list = true. However, when the
end user accesses to drop down, they are able to change the underlying
table's data.
The table's values are:

A - Day
B - Day
C - Night
D - Night

After accessing the drop down combo boxes (forward typing) the user can change the value to:

B - Day
B - Day
D - Night
C - Night

Without any prompts alerting the user of the changed data potential.
Click to expand...
These, table are not part of the query behind the main form. The table(s)
being used as a row source are lookup tables, used to only plug in the
foreign key value in the form(s) main table. Could it be that, since it's
not a different value (i.e. E, F, G, H) that the changes take place? It
should not, correct?
 
Back
Top