Using function from form in Access SQL statement?

Question

I know if I make a code module in Access and place a function in it, I can run a query that has embedded calls to that function. However, I want to know if I can get a function that belongs to the code part of a form to be recognized by Access in a query. So far I cannot find a way, but it seems to me that this should be possible.

Thanks, Cameron

DJ. · Accepted Answer · 2009-04-14 04:21:38Z

2

You can - the function has to be made PUBLIC and the form must be OPEN when you run the query.

Most of the time I put all common functions in a separate code module.

answered Apr 14, 2009 at 4:21

DJ.

16.3k3 gold badges45 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Cameron Over a year ago

Oooh. Thanks! The reason I want to keep as much code belonging the form as possible is because everything I do will eventually have to be copy-pasted into different databases... So I'm trying to keep everything tied to a few necessary forms

David-W-Fenton Over a year ago

Also, you have to refer to the function as a member of the form, e.g., Forms!MyForm.MyFunction().

Collectives™ on Stack Overflow

Using function from form in Access SQL statement?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related