Field Dependent on Combo Box

[mklitwin]

you kind of lost me with the example - i see kind of how its working but i dont want to waste your time here since you answered my question.

bascially in the most simplest of forms is it possible to have 2 combo boxes depend on eachother ie i pick e1 and entity 1 popps up or vis versa.. and of course their values get recorded in their proper locations?

 

[mklitwin]

scratch that - i got it, i was using column 2 instead of 0 (didnt knwo you could use 0, since i was wondering why it started with 1)

fantastic Bob, cant thank you enough

 

[mklitwin]

Another question (which i have half of the answer to), i have a bunch of entity codes which begin with E and some which begin with other letters. I would like another box (the location books held) box to automatically populate with a certain name if an entity with an E as the first character is selected.

I got this code in the entity code after update field, which clearly updates this field regardless of whether its an E or not... is there anoter function i can say, if the left character is E for then populate this field, otherwise leave it blank

for those of you who understand excel somethign like this formula:
=IF(LEFT(Entity Code,1)="E","Location 1","")

Me.Location_Books_Kept = "Location1"

 

[vbaInet]

The Access vba equivalent to IF is IIF. Syntax is the same.

 

[mklitwin]

worked perfectly

 

[vbaInet]

Goodie!!!!