By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

combo box - requery question

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.