Requery error again??? (Subforms and Filters)

N

Neil M

Hi,

I seemed to have lost the thread from before - so here is my problem that is
still unreolsved as before;


I have a MAIN form with unbound combo boxes on it.
These are LEARNER, RESPONSIBLE and STATUS

On the main form there is a MAINSUB subform (datasheet) which changes upon
changing the Status combo (I would like it to change with all 3 combo boxes
but I can sort that out later!)

My error is this - when I change the STATUS combo I use this code;
Me.MainSub.Requery

This requeries the subform within the form and changes the filter depending
on what has been selected in the combo boxes for Learner, Responsible and
Status. (via query linked to combo boxes)

But every time I change the status field and the subform requeries (even
with no data) it adds a blank record to the database? how do I stop this
doing it... Is there another way to work the coding and the requerying of
the subform?

Thanks,


Neil M

P.S. This is getting rather urgant so I hopefully can find an answer on
here.
After this I have the problem of getting the 'all' added to the combo boxes
and working. (which I have instructions to do but i need this part completed
before I carry on)
 
Top