Search via a ID Auto-number

[james1123]

Hi there, just wandering if anyone can help me here; I want to make a query searching records by the Unique id auto-number. any help would be great.
Thanks.

 

[the_net_2.0]

that's really vague james. autonumbers only guarantee a record uniqueness, so searching by using them as criteria is really impossible, unless you mix other criteria in with it.

other than the unique aspect that these creatures provide, there is absolutely no other purpose to them, nor were they probably created by MS for any other purpose.

 

[james1123]

i am making a customer database and we are selling PC's, so we put all of everyone's information into this database and every PC gets a unique key (the auto number) for customer support reasons i want to make a search using this number. so for example if the unique key was 2468 i want to be able to put in 2468 and then pull out the customer records.
Thanks.

 

[the_net_2.0]

if that's all you want to do, you can simply bind the query to another object, like a subform on your search form. the query would be something like:

select * from table where id = forms!yourform!controlName

does that make sense?

search forms are so incredibly common, that you might want to consider using that good 'ol ''q'' box on google's page to download some samples.

but your approach, if you're using it like the method in which call centers are now approaching internal controls and security, then it is wise I think. Most people that I talk to now in those departments actually can't access accounts without a customer number or account number, pin, etc...

so if you're using the id field for the same reason, I suppose that makes perfect sense for future support.

 

[james1123]

Thanks very much for your help, exactly what i needed.

 

[the_net_2.0]

glad to make the day!