Hi I have created a function with 8 cases that determmines what fields will be displayed in various circumstances. How do i call that function within another function?

Please help I am Sooooooo frustrated

That first function needs to be in a STANDARD module and be declared as PUBLIC.

So,

Public Function MyFunction() As String

as an example and then you call it by using

Public Function My2ndFunction() As Whatever
MyFunction
End Function

I am still coming up with a compile error. Am i right in assuming that depended on the result of an if function i can call on various cases from the case function.

ie if Cproduct = "blah" or "blow" then
Mycase function(case1)

How about posting the code for the two so we can see what you're doing?