Query in VBA

[k209310]

How can a query be run in VBA code? I have q query which transfers data from one table to another however i would like the code in VBA. is this possible?

Thanks for any replies given.

 

[ColinEssex]

DoCmd.OpenQuery ("QueryName")

Col

 

[k209310]

thanks for the replies (Both of Them)

I have a query to copy a row and insert it in to another table depending upon a result selected from a combobox.

The method you suggested works fine if the saved query has a number in it instead of "& combo0 "&. (is thjis the correct way to do this?

I was hoping to run the query from with in VBA to allow the query to work correctly.

Im open to ideas. Every thing i have tried so far has produced an error.

Thanks again for the help.

 

[ColinEssex]

what is the "& combo0 "& ??

is that in the query criteria referring to a comboBox on a form?

If so it should be Forms!FormName!Combo0

Col

 

[k209310]

Thanks for that colin.

Im glad you pointed that out - im so used to working with VBA in excel i sometimes forget that there are differences.

Thanks again

Chris