Search results

Bob.. any suggestions for my issue. Please let me know if its possible in Access.

The code and other things had been working perfectly for me.. but my initial issue is the Data sheet window popping up after i select a name from the combo box which i dont want as i am displaying the same information in the form of a Report....I want to know the way to supress this window from...

Bob, would u need any more information on this to assist me.. Appreciate all your help on this...

Bob, PFA a simulation on wat i am trying to do as my database size cannot be lowered to the size u specified... Appreciate all your help on this Bob...

Bob, Apologies for the extended trouble.. is there any example which i can see to understand how to do this... I am not sure if i set the rowsource to this query how will i populate the Combo Box Values and were should i be using "Me.CmbBXG.Requery to requery the combo box" and how.

Bob, Would appreciate your assistance on this...

Bob, Please find below the small piece of code and the screen shot of wat i am trying to do.. Combo Box Change Event code: Private Sub CmbBXG_Change() DoCmd.OpenQuery "Variance" End Sub View Report Command Button Click Event Private Sub View_Report_Click() On Error GoTo...

The 1 which contains the data for the report is popping up as Datasheet which i am displaying in the form of a report and i dont want this to popup.

Thanks for your inputs Bob,, I am calling this report from a Form and i am generating this report based on the value chosen in Combo Box. So its a Dynamic Query which gets executed for every change event on this combo box & its a select query which is being used for the report... any help is...

I am trying to take input for my reports based on a query result dynamically for which i dont want to display the Datasheet after the execution of Query ,inturn i am displaying results in Report. Any help on this would be appreciated.