Thread: Access Help (again!)
View Single Post
Old 16-08-2007, 10:47   #15
gazzae
cf.mega poster
spankthemonkey Champion
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 33
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Access Help (again!)
Quote:
Originally Posted by Damien View Post
IIf(IsNull([Forms]![Contacts]![Combo28]),[Department],[Forms]![Contacts]![Contacts])

I am doing Department | Contacts first. Remember that the contacts form is a subfrom in the department form.

It should be..

IIf(IsNull([Forms]![Contacts]![Combo28]),[Department],[Forms]![Contacts]![Combo28])


try just putting in..

[Forms]![Contacts]![Combo28]
gazzae is offline   Reply With Quote