jlspickler
New member
- Local time
- Today, 11:45
- Joined
- Jan 9, 2014
- Messages
- 7
Hi all,
First some background:
I have created a database for bird banding and breeding data with three tables and several data entry forms. I have also made a search form and used a command button to run a query based on 4 fields within my 14-field table. the idea is that if I only have partial information on a bird, I can look it up using any combination of those 4 fields, even with some of them being blank.
To do this, I set up the query in a wildcard fashion, for example:
Like "*" & [Forms]![frmBirdSearch]![USFWSBand] & "*"
The problem:
Three of the unbound text boxes I use to search records work with no issue. HOWEVER, when I search using the band number, no results are returned even if I have pasted them directly form the database table. If I use band number in conjunction with one of the other 3 search boxes, I still get nothing.
I believe the issue stems from me using the band number (which is a text field because of dashes) as the primary key in that table, but I could be wrong.
Let me know if my explanation of my issue was unclear, and thanks for any assistance!
Jessica
First some background:
I have created a database for bird banding and breeding data with three tables and several data entry forms. I have also made a search form and used a command button to run a query based on 4 fields within my 14-field table. the idea is that if I only have partial information on a bird, I can look it up using any combination of those 4 fields, even with some of them being blank.
To do this, I set up the query in a wildcard fashion, for example:
Like "*" & [Forms]![frmBirdSearch]![USFWSBand] & "*"
The problem:
Three of the unbound text boxes I use to search records work with no issue. HOWEVER, when I search using the band number, no results are returned even if I have pasted them directly form the database table. If I use band number in conjunction with one of the other 3 search boxes, I still get nothing.
I believe the issue stems from me using the band number (which is a text field because of dashes) as the primary key in that table, but I could be wrong.
Let me know if my explanation of my issue was unclear, and thanks for any assistance!
Jessica
