Query with parameter not always working

[Elie00]

Hey guys,

I have a table called "Jobs" with different fields, most are picked from list. Some lists are look up field from an another table for example "port list" and other were typed directly "I will type in the value...", let's call it "shipment type".

My issue is with a query that's using this table, I created a query to lookup jobs from a specific port but it's not returning with any result.
When i create the same query for for shipment type, it's working perfectly.
May i remind you that port is lookup from the another table and shipment type is type in the value.

Is there a way to make this work?

 

[Minty]

If your table has a lookup field you'll find it's not storing the value you think it is.
http://access.mvps.org/access/lookupfields.htm Have a read

 

[Elie00]

So i'll have to input the port names one by one in the lookup field? even if i have hundred or names??

Any other way?

 

[Minty]

If you already have them stored then no you should be able to make a table for your ports and import your existing data. Then use the new table as your source for the combo box.

if you can post up your table structure, we can probably help extract the information.

 

[Elie00]

Hey Minty,

sorry i took too long to reply but i had put that project on hold.
Anyways I solved the issue by deleting the automatic ID key field and kept the port names and it works fine now!

Thanks.

 

[Minty]

Glad you got it sorted!