Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Referencing a subform control value in a second control's Row Source SELECT statement.

Posted on 2008-11-10
5
Medium Priority
?
426 Views
Last Modified: 2013-11-28
How do I reference a user input control on a sub form in a second control's Row Source SELECT statement?

What I have:

   SELECT Table1.Field1 FROM Table1 WHERE Table1.Field2=Me!SubForm1.form!Control1;

is not working as expected. The resulting list uses the Control1 value from the static form, not the currently entered value in Control1.

Kevin
0
Comment
Question by:zorvek (Kevin Jones)
  • 3
  • 2
5 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 2000 total points
ID: 22928358
Hi zorvek,

Instead of Me! put in the whole form name.
Also after entering the value in Control1 do a requery.

Good Luck!

Gary
0
 
LVL 81

Author Comment

by:zorvek (Kevin Jones)
ID: 22928375
I knew that! Once. A long time ago.

Thanks!!!

Kevin
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22928385
I'm honored to be able to help Royalty!
0
 
LVL 81

Author Comment

by:zorvek (Kevin Jones)
ID: 22928399
Oh, please. A lot of long, lonely nights and a knowledge base full of canned answers. :-)
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22928448
"The modest person is usually admired, if people ever hear of them." Edgar Watson Howe
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question