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

Record selection problem, two linked subforms

P: n/a
TD
I have a main form which is unbound. On this form I have two subforms
that are linked thru an unbound textbox on the main form. Both both
of the subforms are in datasheet view. This setup work great, whenever
I select a record in subform1 subform2 is populated with the records
for the item selected in subform1. The problem is with subform2. If,
say it has three items showing, if I select the second item down the
list it stays selected for half a second then item one is selected. I
have checked everywhere in my code but cannot find anything that
forces subform2 to be requeried, which is what looks like is
happening. Any ideas?

Thanks,
TD

May 7 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
TD
On May 6, 11:00 pm, TD <d...@adsi-sc.comwrote:

Anybody???

TD
May 7 '07 #2

P: n/a
Is anything setting the recordsource of subform2? (this causes an automatic
requery)

"TD" <dl**@adsi-sc.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
On May 6, 11:00 pm, TD <d...@adsi-sc.comwrote:

Anybody???

TD


May 7 '07 #3

P: n/a
TD
No, it's recordsource is a select statement that uses a where clause
that reads the value of the unbound textbox on the main form. The
value in the textbox is not changing.

Thanks for answering though...
TD
May 8 '07 #4

P: n/a
Ok, is there any code in subform2's OnCurrent event? How about code in the
leftmost column's OnEnter or OnFocus events?

"TD" <dl**@adsi-sc.comwrote in message
news:11********************@q75g2000hsh.googlegrou ps.com...
No, it's recordsource is a select statement that uses a where clause
that reads the value of the unbound textbox on the main form. The
value in the textbox is not changing.

Thanks for answering though...
TD


May 8 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.