Using A REcordet

[FontanaS]

I am writing the recordset in code.

I get the value the user types in on a from and then search a table for the records that match what the user types in.

The problem is that the value the user types in might have multiple hyphens in it. There are hyphens in the table also, but I keep getting a not found message.

Ex - user types in 01-G-AW-MISU
Ex - in table says 01-G-AW-MISU

They are the same but it doesn't find it.

Any suggestions as to why this happens? I do not know if you can't have hyphens in a search string.

 

[LonnieJohnson]

Two questions.

1. What event triggers the report? Is it the user hitting enter? Clicking a button?

2. In your query that get's your criteria from the form, what is the expression that's used to reference the from?

B-) ljprodev@yahoo.com
ProDev
MS Access Applications