add to group using macro

L

Loxsie

hi there

im creating a table query using a macro.
so as soon as i create the table it displays at the bottom of my navigation
pane.
i would like to link that table to the corect group usuing the macro.
i could right click on the item and say "add to group" and then select the
group but that takes time.
my macro at the moment looks like this verry simple.


DoCmd.OpenQuery "WaterfrontPLU FCost%", acViewDesign, acReadOnly
DoCmd.RunCommand acCmdQueryTypeMakeTable
DoCmd.RunCommand acCmdRun
DoCmd.OpenForm "frmWaterfront", acNormal, "", "", , acNormal
DoCmd.Close acQuery, "WaterfrontPLU FCost%"
DoCmd.Close acForm, "frmMainScreen"

hopes this helps


Thank you
 
Top