Forum Discussion
Fields randomly populating
I have a database with a main form and several subforms, one of my subforms keeps randomly populating fields when data is entered into another field. Both fields are drop downs and are not linked in ...
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.