Weird one this?

[Sam Summers]

Hi,

I have a hunch on this one but cant seem to clear it?

I have comboboxes on forms that i have entered the values for the drop down list in.
They are on a form with textboxes and go through a one to many relationship via an intermediate table.
I deleted one value from the list as it was no longer required and i also deleted the records that used to use that name.

When i looked at the list, the value is still there?

I tried inserting a new Combo Box - the same?

Tried re compiling - still the same

Will it clear if i create a new blank Database and import everything?

It must be stored in memory somewhere?

Thank you in advance

 

[pr2-eugin]

What is the RowSource and RowSource Type of the comboBox?

 

[Sam Summers]

RowSource is "Rope Access";"Fabric Maintenance";"Mechanical Integrity";"Pipeline Integrity";"Rigging and Lifting"

RowSource Type is Value List

What keeps coming up in the list is "Scaffolding" which i have deleted?

 

[CazB]

So... just remove the one you don't want from the value list?

 

[pr2-eugin]

Are you sure that the ComboBox values are not changed using CODE in any methods?

So... just remove the one you don't want from the value list?

CazB, Thought this was already done by the OP..

I deleted one value from the list as it was no longer required and i also deleted the records that used to use that name.

 

[Sam Summers]

I went into the code window and did a search for "Scaffolding" and compiled as well and nothing came up? It must be sitting somewhere?

I have just gone through the queries and deleted any reference in them too

 

[pr2-eugin]

Strange one ! Could you upload a Stripped DB?

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[Sam Summers]

Thank you
If you open form EnterJob the problem is in the "Type" Combobox which is still displaying "Scaffolding" even though i have deleted it?

 

[CazB]

it's on the TABLE design, on the Type field..... the Display Control is set to ComboBox and Scaffolding is still in the Lookup list in there

 

[Sam Summers]

Ha Ha, of course!

Brilliant! Thank you for showing me the error of my ways.
Funny how you can miss something SO obvious sometimes!

 

[CazB]

no probs - glad to be of service