Access 2002 - Problems with data lookup

[Malcolm Potter]

I am attempting to design a form to enter data into a table called
tblClarkResults. Among other objects on this form I want two comboboxes with
different field names (Name and Partner) to lookup their data from the same
field (Name) in another table (tblPlayer) which is fully populated with base
data. When I have selected a name in each combobox I want associated
Handicap data to be automatically displayed on the form in the
PlayerHandicap and PartnerHandicap boxes. Although I have managed to get one
of these systems working OK, I have not yet managed to get the two working
together. When I tab into the player handicap field, after selecting a
player's name, the system automatically inserts the correct data in that
field but a copy of the player's name and handicap then appears in the
Partner and PartnerHandicap fields. I am fairly new to Access 2002, so any
help would be gratefully received.



Thanks



Malcolm

 

[Rick Brandt]

I am attempting to design a form to enter data into a table called
tblClarkResults. Among other objects on this form I want two comboboxes with
different field names (Name and Partner) to lookup their data from the same
field (Name) in another table (tblPlayer) which is fully populated with base
data. When I have selected a name in each combobox I want associated
Handicap data to be automatically displayed on the form in the
PlayerHandicap and PartnerHandicap boxes. Although I have managed to get one
of these systems working OK, I have not yet managed to get the two working
together. When I tab into the player handicap field, after selecting a
player's name, the system automatically inserts the correct data in that
field but a copy of the player's name and handicap then appears in the
Partner and PartnerHandicap fields. I am fairly new to Access 2002, so any
help would be gratefully received.

Sounds like you have the two sets of controls bound to the same fields in your
table. Did you perhaps copy and paste to create the second set and forget to
change the ControlSources?

(If I had a nickel for every time I did that ;-)

 

[Malcolm Potter]

Rick

You are right. The control sources are 'Name' for both the 'Name' and
'Partner' fields and 'Handicap' for both the 'PlayerHandicap' and
'PartnerHandicap' fields. I thought that selecting a different 'Name' in the
'Partner' combobox would automatically lookup the 'PartnerHandicap'
associated with it, but obviously not. I suppose the next thing to do is
investigate the underlying query since, at the moment, I can only select
either 'Name' or 'Handicap'.

Thanks

Malcolm