Changing the Control Source

[Nitrous270]

I have a combobox (cmbReleaseID) that I want to change the control source on from ReleaseID to CompReleaseID depending on the input given on a previous combobox (cmbArtist). So ...

If cmbArtist = "Comp" or "Sndtrk"
Then cmbReleaseID control source = CompReleaseID
Else cmbReleaseID control source = ReleaseID

Note: I know this code isn't useable i just thought it would help explain my problem.

Thanks,
Nitrous270

 

[UrbaneRove]

Nitrous270 (TechnicalUser)

If cmbArtist = "Comp" or "Sndtrk"
Then cmbReleaseID control source = CompReleaseID
Else cmbReleaseID control source = ReleaseID

me. should be Forms!("form name&quot. but you didn't give teh name.

sub cmbArtist_onLostFocus()

if me.cmbArtist.value = "Comp" then
cmbReleaseID.value = "CompReleaseID"
elseif me.cmbArtist.value = "Sndtrk" then
cmbReleaseID.value = "CompReleaseID"
else
cmbReleaseID.value = "ReleaseID"
end if

end sub


Something like that.

Hope it helps

Urbane Rove