Module or query

[Striker]

Can anyone point me to a simply module that handles executing a SQL
statement, then populating a form with the results?

I'm finding VBA for Access2007 very different from when I learned VBA 6
years ago.

I'm wondering if there is any advantage in pre-defining queries, as the
person before me did. Or is it better to place the code in a module and
execute it on command. Then pop the date into a form. At least this way I
can do some error checking and validation before updates are made.

Do these sound like an Access Newbie questions?

Thanks

 

[Beetle]

It depends somewhat on what you're doing. In some cases
it might be better to have a stored query, other cases it might
be better run SQL in VBA.

Can you give us some more info about what exactly you
are trying to accomplish?

_________

Sean Bailey