Param qrys and vb modules

[=?Utf-8?B?VW5kZXJTZXZlbg==?=]

Two questions,

Can a param. qry take a varaible passed to it from VB as the param and if so
how, if not what is a good work around?

Second, can a module be used to call an update qry? I've noticed on events
seem unable to call update qrys, but I want to use on events to update tables.

Thanks

[RobinS]

1: You can pass the value of a variable, but not a variable itself. I'm not
sure what you mean by this. I pass in a variable to my SP's that i call
RowState, and it is used in my SP to decide whether to insert, change, or
delete the record.

2: Why not? Just call the module from your event procedure, or point the
event to the module.

AddHandler myButton.Click, AddressOf IReallyWannaDoThis

Public Sub IReallyWannaDoThis(sender as Object, e as EventArgs)
....

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-------------------------------------------------------------
"UnderSeven" <Un********@discussions.microsoft.comwrote in message
news:30**********************************@microsof t.com...

Two questions,

Can a param. qry take a varaible passed to it from VB as the param and if
so
how, if not what is a good work around?

Second, can a module be used to call an update qry? I've noticed on
events
seem unable to call update qrys, but I want to use on events to update
tables.

Thanks