Using the same value in a field

[John Big Booty]

I believe that the reason this code is not working is because you are using Table Level Lookups. Congratulations you have stumbled upon one of the reasons their use is discouraged.

See this thread for further discussion on the subject and how to fix your DB.

[John Big Booty]

Originally Posted by missinglinq

You've got a machine with Access 2008 on it?

'07 actually but what's a year or two either way between friends

[Robbieb29]

I have looked at both threads, and copied the text into my form, but still the fields are not continuing to display the text.

I have attached my Database, please tell me what im doing wrong

[boblarson]

Since I do not have Access 2007 here at work, I will have to take a look after I get home in about 10 hours. If anyone else has it and wants to look, feel free.

[John Big Booty]

You've made no substantive changes to your DB. You need to move those Table Level look Ups into their own tables and then use Combo Boxes.

Go and re-read this thread particularly post #8 also follow the three links in that post. Once you have read and understood the concepts discussed there you should be able to move forward.

[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]

Originally Posted by 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.

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]

Originally Posted by John Big Booty

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 )