Module or query

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

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

"Striker" wrote in message
...
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