Help with duplicate field data

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Thanks to tips picked up here I am slowly learning this thing. Using Access
2007

I have a form with four combo box fields that gets data from one field in a
table. I need to ensure that the data is different in each field. I found
the below link and tried it thinking it may help but it doesn't do the job ,
unless I am doing it wrong or its just for 2003. 2007 has the same options
so it should work. I am following the multiple field index option

http://office.microsoft.com/en-us/access/HP051875641033.aspx

If the above isnt the solution maybe a before form update procedure could
work? If so please advise how to do it

Thanks for the help and just a note, I don't know any VB code
Bill
 
Bill

I'm having trouble visualizing your situation...

Are you saying that your 4 comboboxes on your form ALL get data from a
SINGLE field in a table, or that each combobox gets data from a separate
field?

And by "gets data", do you mean that the control source of the combobox is
that field, or that the source of the drop-down info (Row Source) is that
(one or more) field(s)?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff

Yes all four fields get data from a single field in a table. The Row Source
of all four comboboxes on the form is that same single field

Maybe if I explain what I have attempted to do it might help

We have a pretty large group of card players, and I have all their names in
one table. The game is a partnership game. And any given night any two in
the group can be partners. I am trying to keep track of the games, winners
losers etc etc

In addition to the Players table with the single name field, I have another
table to enter results of the games and I have it designed as:

GamesPlayedID
Winner NameA Field1
Winner NameB Field2
Loser NameC Field3
Loser NameD Field4

On the form to enter the info I will have

Winners : Jeff and Bill
Losers: John and Mary

What I need to prevent is the possibility of Jeff and Jeff or Bill and Bill
in any of the four fields

Maybe I designed the whole thing badly but I hope you get a better idea

Thanks

Bill
 
Back
Top