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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access/SQL select view
Yes, the Combo Box takes me to the first record with the selected ClientName but after that I can navigate all the other records from the form regardless of ClientName. Clive.- clive5
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Access/SQL select view
I don't get any choices at all; I select the "Find a record on my form based on the value.....", then I select the field, then it asks me to label the Combo Box and select Finish (the Next button is greyed out). Clive.- clive5
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Access/SQL select view
Thanks Fuzzy, I've got to the point where I can select the ClientName in the ComboBox but the wizard did not ask me if I wanted to store the value of the selected clientname for later use so I can still see the records for all clientnames. Is it the SQL database that's causing the problem? Clive.- clive5
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Access/SQL select view
I have a simple SQL 2000 database with an Access 2000 front end. There are 3 tables, CLIENT, CONSULTANT and WORK. The WORK table references Client_Name and Consultant_Name from the primary keys of the other tables. There is a WORK_INPUT FORM which displays all the WORK TABLE fields with Combo...- clive5
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
