Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XP - Using a drop down in a query

Status
Not open for further replies.
JoseQuiervo

JoseQuiervo

Programmer
Sep 25, 2002
57
0
0
US
I currently have a query for data entry on one aspect of my database. I have two fields with drop downs. However, one of the two (TestType) is based on the other (TestName) in the table. Is there a way to select the data in the TestName field and have it automatically populate the TestType field in the query? I know how to do it in a form, but not sure how it work in a query. Please let me know what you guys think. Thanks a lot. I appreciate it.
 
Sort by date Sort by votes
No.
Code has to run to requery the rowsource of the second drop down. Therefore you can't do it in a query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
275
grnzbra
grnzbra
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
173
TheresAlwaysAWay
TheresAlwaysAWay
swicor
  • Locked
  • Question
Exact match using access upper and lower case
Replies
0
Views
99
swicor
swicor
iamchemist
  • Locked
  • Question
Access Slow Down??
Replies
3
Views
71
iamchemist
iamchemist
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
144
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top