Param qrys and vb modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top