Refreshing data

[GerardMcL]

Hi everyone,

I have an Access 2000 form. I add an item to a table then refresh the form hoping the changes would be reflected in the subreport I have set up to show table contents.

I dont have any of the wizards running so I have hard coded pretty much all of this.

The problem is when I refresh the form I just get a white square back where my subreport used to be.

I have programmed in VB6 for a few years and I gotta say Im finding Access very frustrating.

Anyone know why this happens?
Interested if anyone has a better way of refreshing data?? I get similar problems when I try to refresh data in a combobox - even when I try things like
cmb1.RowSource = "SELECT Col1 FROM Table1".

Thank You for all your help.
A Big grateful CHEERS to you all!

 

[IGPCS]

fisrt if you dont have the wizards runing and you dont know how to turn them on so on the toolbox toolbar next to the mouse there is a wizard button make sure its selected

and yes if you are used to vb ms access is really frustrating i went past that as well

about the refresh please check the relation ships of the form and maybe try to use me.refresh or me.recalc

hope you got it i am not exactly sure whats you code

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY