how to hide a value in a lookup field

[janeyg]

Hi

I have a table which has a lookup based on another table. This look up is used in a form. I have a colleage who wants to hide certain values temporarily in the lookup field. i.e 'Work shop names' which are only available certain time of the year, so rather than have a big list to choose from, they just want to reduce what is shown to choose from that is relevant. I thought of adding the word HIDE to the end of the value in the table and then when they wish the value to be visible again, they could just delete the word hide and it would appear in the lookup list again but I don't know what code to use to action this in the form where that look up appears?

Or is there a better way to acheive this - more than one value may be hidden at a time.

Does anyone have any idea's? I can find codes to hide values based on certain lookups being chosen and then hidden in the next lookup but not to hide values in just one lookup.

Any help would be appreciated.
thanks
Janeyg

 

[vbaInet]

Lookups in tables are not recommended. See here why:

http://access.mvps.org/access/lookupfields.htm

You should be using Combo Boxes in your form.

 

[pr2-eugin]

Hi Janeyg, it is considered a very bad practice to have lookups in your Table level. check out this link.. http://access.mvps.org/access/lookupfields.htm

If you need to achieve this on a Form level you can do so, the simple way I can think of would be.. Add a field called 'NotAvailable' to the table whose values will be in the combo box, with Yes/No type. Then check the ones that are not available.. and use this as the criteria to eliminate/HIDE..

EDIT: Didn't see you there vbaInet.. LOL

 

[vbaInet]

EDIT: Didn't see you there vbaInet.. LOL

Invisble sometimes

 

[boblarson]

Invisble sometimes

The Shadow.....

 

[vbaInet]

The Shadow.....

Looks like someone is a Batman fan.

 

[boblarson]

Looks like someone is a Batman fan.

Batman?????

 

[vbaInet]

I thought he featured in one of the Batman movies. Must have confused him with someone else.

I think I watched it a few months ago on a plane. I seem to recall the "invisble" hotel.