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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem with lookup field
Requery the form how?- purksd
- Post #9
- Forum: Microsoft: Access Other topics
-
problem with lookup field
More information.....If I then enter a value in the popup box (for example, Building 2), the correct list of values for Room is displayed. When I go to the next record and change the value of Building to Building 3, when I go to the Room field it doesn't display the popup box again -...- purksd
- Post #6
- Forum: Microsoft: Access Other topics
-
problem with lookup field
This gives me the same thing I've seen before - a popup that says <br><br> Enter Parameter Value<br> Forms!Name/Location!Building<br><br>As for my last question.....Let's say that the computer is being moved from Building 1...- purksd
- Post #5
- Forum: Microsoft: Access Other topics
-
problem with lookup field
I must be missing something....Under the Lookup tab, Row Source, if I enter quotes around the select, I get an error: The Microsft Jet database engine cannot fine the input table or query "'SELECT Rooms.Room .... ;'". Make sure it exists and that its name is spelled...- purksd
- Post #3
- Forum: Microsoft: Access Other topics
-
problem with lookup field
Table 2 (Rooms) has the following fields:<br> Building (primary key)<br> Room<br><br>Table 2 (computers) has a bunch of fields including:<br> Building<br> Room<br><br>While doing data entry in Table 2, the user has entered data in the Building field (using a pulldown). When entering data for the...- purksd
- Thread
- Replies: 8
- Forum: Microsoft: Access Other topics
