Are you saying you have duplicate data being displayed in two subforms? Otherwise, why would either subform need to be refreshed because something was changed or added in the other?
To convert values entered in a combobox to uppercase, this was the code I used:
Me!Code = UCase(Me!Code)
The desired result was implemented in the control source (field in underlying table), but the row source of the combobox of another form that is this field in the underlying table was not converted to uppercase.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.