Function not working when no records to display - any ideas?

N

Nigel

Hi there,

I've a title field on each of the forms in my database. I set the
contents of this field with a function. This works fine on forms that
do not rely on a table or query (e.g. Report Selection Forms) and it
works for forms that display the contents of a table or query provided
the table or query has some records in it, BUT if the table or query is
empty the title field remains blank.

The function I have created looks like this:

------------------------------------------------------------
Global Const dbTitle = "DATABASE TITLE"

Function fGetDbTitle() As String
fGetDbTitle = dbTitle
End Function
-------------------------------------------------------------

And the title field has control source set to: =fGetDbTitle()

Has anyone any ideas how I can get this to work for forms relying on
tables/queries where there are no records to display?

Thanks in advance,

Nigel

p.s. If you wish to reply by email please address your reply to
[email protected] (removing the letters in capitals)
 
Top