This question involves using VBA behind a Combo Box. The Combo Box is bound to table CI and a field called APlayer. The search is on a field called LastName in another table PL. The objective is to get a second field, PlayerName from PL, stored in APlayer in the table CI. That seems to work OK, but the Combo Box on the form continues to display LastName, not the value in the bound field, PlayerName. I’ve even used code in an AfterUpdate event to search PL and place PlayerName in the form field with the command Me!APlayer = PL(“PlayerName”). That doesn’t work either and there are no error messages. I must be violating some basic rule about Combo boxes. Anyway, any help would be appreciated.
Phil H