Forum Discussion
Fields randomly populating
It's impossible to guess what might be happening from the overview provided.
It can't be random, but without seeing the actual process in action, and having a good description of the context, we could only guess.
There are a few ways to complete the picture. One of those would be a sample database with just enough sample data to see the problem. Another would be screen shots.
Thanks in advance.
George_Hepworth in this screenshot if I select any choice in R Pupil Rxn the Cardiovascular description populates.
These are the field properties
If I try to save the database with only this form the problem goes away, it will also occasionally go away if I compact and repair but it always comes back the next time you open the database.
One possibility is that the action of selecting a value in that combo box for R Pupil Rxn initiates a new record. That then populates the other dropdown, Description with a default value for new records, i.e. "Regular".
Does the same thing happen on existing records?
George_Hepworth It happens on both existing and new records.
- That means something in either a macro or a VBA procedure is setting it. Search for references to that control in the VBA and/or in the macros.
