J
jim
I have set up the main form with 4 fields from the company details table, the fields are (product class, product class 2, product class 3, product class 4) these have data in that is returned from another table called ProductFilterClass using a combo box.
it returns the company names and telephone numbers in a subform if the the data selected matches.
When I select from the first field the company names are displayed without having to run a requery macro, but if I don't have a requery macro set for the other 3 fields in the AfterUpdate Event nothing happens in the sub form.
But when I do it updates the subform BUT changes the data in ROW 1 in the company details table how can I stop this happening but still get it to requery the subform.
A bit stick any help would be great.
it returns the company names and telephone numbers in a subform if the the data selected matches.
When I select from the first field the company names are displayed without having to run a requery macro, but if I don't have a requery macro set for the other 3 fields in the AfterUpdate Event nothing happens in the sub form.
But when I do it updates the subform BUT changes the data in ROW 1 in the company details table how can I stop this happening but still get it to requery the subform.
A bit stick any help would be great.