VB programmer new to Access

  • Thread starter Thread starter kflash
  • Start date Start date
K

kflash

I'm a VB programmer new to working with access. I want to run a query
(Insert into Query) each time the user changes a value in a combo box.
Could someone walk me through the steps to do this?

Thanks,

kflash
 
If it is an action query (update, delete, or insert), I suggest you use
the AfterUpdate event procedure of the combobox, and use:

DoCmd.RunSQL "savedActionQuery"


or something like:

On Error Resume Next
DoCmd.SetWarnings = False
DoCmd.RunSQL "savedActionQuery"
DoCmd.SetWarnings = True


Using DoCmd, the saved action query will automatically solve for
parameters,if you have any, having the syntax:

FORMS!formNameHere!SomeControlNameHere




Vanderghast, Access MVP
 
Back
Top