470,599 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,599 developers. It's quick & easy.

combo box - requery question

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

Nov 13 '05 #1
1 1767
I'm having the exact same problem, and it is a common issue, evidently
with how Access handles continuous forms. I haven't found a solution
that works for me, but evidently there is a solution here
http://www.daiglenet.com/msaccess.htm. Scroll down and download the
SynchCobmoContinuous.zip file. There is a sample database that I
believe does what you want. This is the only solution I have found
where I have seen a working database.

I have been trying to figure this out for about a month now with no
luck.

Good Luck!

dskillingstad

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Lucinda Roebuck | last post: by
3 posts views Thread by geribosi | last post: by
1 post views Thread by Jeff_F | last post: by
3 posts views Thread by dmkeith2 | last post: by
2 posts views Thread by Sid | last post: by
13 posts views Thread by mirandacascade | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.