Question Search in forms

[RonnieODIN]

Hi all,

I am trying to make a search function for my DB. I am using agehoops' example db shown in the following thread:

Search Function, of February 16th 2007

My problem is, that the table I am referring to in my search-query has some looked up fields. These fields are returning an ID-number to my query rather than the text value I want to be displayed. Anyone having an idea of how I can make this work? :banghead:

 

[jdraw]

You should read this re lookup fields in tables.
http://access.mvps.org/access/lookupfields.htm
then watch this free video tutorial
http://www.datapigtechnologies.com/flashfiles/searchform.html

Good luck

 

[BlindPro]

I think this will help
http://www.access-programmers.co.uk/forums/showthread.php?p=1164301#post1164301

 

[RonnieODIN]

Hey guys,

My search runction itself is working fine.

My problem is that I want to search in looked up fields. These are returning ID numbers which the users of my DB have no idea about - they only know the texts e.g. costumers.

Is it at all possible to get around this issue?

I am very new to Access so I don't really understand the info from the link to hazards of looked up fields.

-Ronnie

 

[shutzy]

does the look up display ok when you look at the table?

how are your search results diplayed? list box?

if it is a list box then change you query

 

[RonnieODIN]

The look ups are displayed correctly in table.

The results are displayed in a list box.

I changed my query to include the tables upon which the looked up fields are based and chose these text fields rather than the looked up field in the main table. I just succeeded making this change recently.

Thanks for your time though.

-Ronnie