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 DelmotOP
@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
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 DelmotOP
@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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.