Using the same value in a field

[John Big Booty]

Particularly the thread concerning Normalisation

 

[Robbieb29]

Thanks for the help, i've cracked it using table query.

Thanks Rob

 

[John Big Booty]

Good work

 

[Robbieb29]

Sorry to be a pain, but now the user is enable to alter the combo box. I need the user to be allowed to add to the combobox, as there will be locations that are not on the list.

 

[boblarson]

Do an Advanced search here on "Not in List" and from user RuralGuy and see if that helps. You should find some things to help.

 

[John Big Booty]

Sorry to be a pain, but now the user is enable to alter the combo box. I need the user to be allowed to add to the combobox, as there will be locations that are not on the list.

Did you read post #12 of the thread I have now referred you to on two occasions, this explains how to use the On Not In List event and the On Double click event to allow the addition of new items to the list.

 

[boblarson]

Did you read post #12 of the thread I have now referred you to on two occasions...

Apparently not (and sorry - I didn't either or else I would have mentioned it )