Computer Learning Zone CLZ Access Excel Word Windows

I have never let my schooling interfere with my education.

-Mark Twain
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Visitor Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
finding record through combobx
Koen Delmot 

2 years ago
context:
I have a table where only values are stored. The values are actually the ID's from other tables. I have made a form for this table. By using comboboxes, users can select the meaningful text from the combobox while only the value is stored in said table.

my goal:
I want to add searchbuttons on that form but since only values are stored in the table, I was in a pinch. I tried to use the technique from this video (https://www.youtube.com/watch?v=qQYOwYHU5jw&lc= ; Find a Record on My Form Based on the Value I Selected in my Combo Box). I thought this would solve my problem because users would be able to select the meaningful text from the combobox while Access would get the selected ID and filter the info.

my problem:
I can't get it to work. Nothing gets filtered, I just end up with a blank form. Is this because I store values in my table instead of text/string?
Thank you in advance.
Adam Schwanz  @Reply  
           
2 years ago
I can't picture what you're trying to do. Can you upload some images?

It sounds like what you're looking for is Search Form 2.0 though, or similar
Koen Delmot OP  @Reply  

2 years ago
Thank you Adam for your reply.
Here are some screenshots. It is a screenshot of the table, form, what happens when I use the search combo and the VBA code I used.
https://www.dropbox.com/scl/fi/1bv5foc65qzklq661qfdy/perceelT.jpg?rlkey=qxg9g9o940henww4ld9jpttl3&st=6p9mso0h&dl=0

https://www.dropbox.com/scl/fi/amh57xiyae11xufbkhxzd/PerceelF.jpg?rlkey=0iqxx58tcy1eptwqa6zvkluq2&st=n7ufmpan&dl=0

https://www.dropbox.com/scl/fi/2ki528n4zqfo6njtmfxpb/searchcombo.jpg?rlkey=lofvp3ha73ofc3fi7beboh3lr&st=kozd5oyh&dl=0

https://www.dropbox.com/scl/fi/ciabl96w0p9m3ajfrt121/VBA-code.JPG?rlkey=5bo6h5hspopjnoj928bhpfrlo&st=x0kdyohr&dl=0
Sami Shamma  @Reply  
             
2 years ago
Koen

use this website "Upload Image" to share images.
Kevin Robertson  @Reply  
          
2 years ago
Sami

As far as I know Visitors in this forum can't upload images (unless that has changed).
Sami Shamma  @Reply  
             
2 years ago
Thank you Kevin

I missed that he was a visitor.
Koen Delmot OP  @Reply  

2 years ago
Yes, I'm a visitor so can't upload pictures. I tried my best to give some info.
Back on topic. Does anyone have any idea what I'm doing wrong or what may be causing the problem?
I have been using Google fo rhelp but so far, nothing has worked.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 2:26:24 AM. PLT: 0s