Julia82 said:
I have a textbox that changes. Inside are names.
I want where the name in my query matches the name in that textbox,
another
texbox displays me the count of duplicates for that user.
I don't know how to get the values from the query and put them on my form
Thanks!
First off, if you're actually using "Name" as a field name then don't. It's
a reserved word in Access and will give you trouble sooner or later. Make it
'UserName' for example.
I would use the Dcount function to obtain the number of dupes:
OtherTextbox = Dcount("UserName", "tblNames", "UserName = '" & MyTextbox &
"'")