Thanks for your answer. What do you mean 'standard module in public scope'?
If I try and enter the function directly, I just get error 3388 when I try and save the table.
This is the code I have:
Option Compare Database
Dim db As Database, rst As Recordset, strSQL As String
Dim tbls As...
I have written a function that I want to use in the 'Default Value' of a field in a table. However, when I open the expression builder, I can see built in functions but not my own. Is there any reason for this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.