I have a continuous form which has two combo box contols on in "Lot"
and "Raw".
The Row Source property of "Lot" is a Select statement based on "Raw".
SELECT [COA Data].lot FROM [COA Data] WHERE ((([COA
Data].Material)=Forms!Formulas![Formula - Raws].Form!Raw));
Lets just say the continuous form has 8 items in it......
The FIRST time I select any one of the "Lot" combo boxes, it populates
perfectly.
Any subesequent combo boxes I select continue to be populated with the
same list as when I clicked the first "Lot" combo box.
If I close the form an open it again, it works perfectly the FIRST time
I click any one of the "Lot" combo boxes.
I tried using a requery in the "Got Focus" and "On Click" Events to no
avail........
Any help would be appreciated.
Doug