Forum Discussion
Klmedellin
Dec 20, 2022Copper Contributor
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
Silver Contributor
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?
Klmedellin
Dec 21, 2022Copper Contributor
George_Hepworth It happens on both existing and new records.
- George_HepworthDec 21, 2022Silver ContributorThat 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.