Using Visual Basic from an update query

[texan1956]

As a new user of Access I need to do two things: 1) create a function, 2) run the function from my update query. I'm pretty sure I can create the function as a module, but how do I call the module from my query?

 

[dneufarth]

What does the function do?

Ordinarily you place it in hte query grid just as you would use Now() or Iif(...) or Cint([x]).


Dave

 

[BlackKnight]

Hi,

Create the module, write the function in the module.

In your query use a calculated field to call the function like:

Coast: GetCoast([CityName])

where Coast is my calculated field, GetCoast() is my function, and CityName is a field in the query.

Have a good one!
BK