Fields randomly populating

New Contributor

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 any way other than being in the same form. 

5 Replies

@Klmedellin 

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. 

Klmedellin_0-1671564484389.png

These are the field properties

Klmedellin_1-1671564639360.png

Klmedellin_2-1671564676684.png

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.

 

@Klmedellin 

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.