form refresh on 2 subforms not working..

[M G Henry]

I have a form with 2 subforms, one subform holds internal ID data and
one subform holds client ID data,

I was using the refresh form feature on a command button to refresh and
put the data into list boxes on the parent form.

The problem I am encountering is that the refresh will work and clear
one suform and put the data on the list box, but on the other subform,
if I change the data, it will change the first line of the list box,
but will not complete different rows on the list box and will not
refresh that subform at all.

I cant see any difference in the structure of the subforms or the 2
different tables that are associated with the subforms, just puzzled...

Thanks,

M G Henry

 

[Ron2006]

Try a requery on the subforms instead of the form refresh.

Ron

 

[M G Henry]

Try a requery on the subforms instead of the form refresh.

Ron

Ron,

That also did not work, it still will only add lines to one of the list
boxes...

Thank you for the advise though...

Even when I recreated the subform it still would not add to this
listbox.

Could it be that there is a problem with the underlying table ??

M G Henry

 

[Ron2006]

hmmmmmm..............

Will have to think a little more on that one.

Is the table actually updated when you look at it in table mode as
opposed to through the listbox query?



Ron

 

[M G Henry]

hmmmmmm..............

Will have to think a little more on that one.

Is the table actually updated when you look at it in table mode as
opposed to through the listbox query?



Ron

Ron,

No, it was not updating, it was just adding one line... it was
puzzling me as to why it was not updating the table, so I went in and
checked the structure and every other aspect against the subform that
was working I found an error with the parent child field link, and
then added a autonumber primary key to the table that the non working
subform was linked to, and now it seems to be working ok.

Thanks for the help !

M G Henry

 

[Ron2006]

Great.

Ron