Unable to search for critera

[Paladon]

Hi everyone

I have a database that I built myself and use on a daily bases for keeping track of customers and there service records for a small sized plumbing and drainage firm. The database has a function that is designed to automatically search for upcoming boiler services that are due or over due which works fine, However we use acronym's to describe some routine jobs such as B/S (Boiler Service) or H/R (Heating repairs) which speeds up data entry. The problem is that Access refuses to search for the acronym's, I have tried basic text search critera's which brings up full words fine such as "Smith".
Is there a way of searching for the acronym's like B/S?

Thanks in advance for any help.

 

[Rich]

You could use a lookup table/combo box combination

 

[Paladon]

Thanks for the reply.
I should mention that the database has alot of information held within it, and the acronym's are all ready used in a text field called [Service Information] which contains information for example "H/R (Heating Repair) supply and install divertor valve to heating system."
I need a way of searching a query to find H/R's but can't get it to function, my querys work if I search using any other fields for information such as [Last Name] but it seems that the [Service Information] field will not allow any form of critera search.
Thanks for any help.

 

[Paladon]

Just an update.

Managed to get the query to function by using Like "*B/S*" in the [Service Information] field.
Thanks for the help Rich.

 

[Rich]

Glad you didn't get too Bogged down