Queries from tables with lookup fields

[Bursal]

I have a contacts database that uses lookup fields for some data and this seems to cause a number of problems!

First: I have a lookup field that the following three options ordinary member, organisational member and associate member but all fields are not populated because there are contacts who are not members. How can get a query to run that will give me a list of members and their types?

Second: I have two lookup fields, one relates to locality and the other state. I run a simple query for a snail mail merge with Word and the query looks fine but the mail merge returns the ID rather the locality and state. I know this is because of the lookup field but how do I get a query to display correctly in the mail merge.

Third: I would like to have a lookup for locality, state and postcode that will return the three values to three fields. When the first letter of a locality is entered you could select a value and the other two values would be added to their respective fields.

The other thing I need to add is I am not good at VBA but I am trying so please be gentle with codes, or at least tell me where they are added. I understand that I will have to change them so that they relate to my tables, queries and fields. I am spend time trying to get a handle on coding because I am going to need it but it is a bit of learning curve.

Thank you for reading my post and I look forward to your answer.

 

[Alansidman]

Item 1: Do you wish to only show the records that have the member field not blank. If so, in your query, put <>IsNull in the criteria for the member field.

Item2: You need to join the lookup table with the main table and have the value from the lookup table visible in your query.

Item3: This is referred to as cascading combo boxes. Here is a link on how to set that up. http://www.access-programmers.co.uk/forums/showthread.php?t=219997

 

[Bursal]

Thanks Alan I will give them all a try and see let you know how I get on.
Di

 

[Bursal]

I think most of my problems are coming from the fact the lookup fields on the table, research tells me that’s a NO NO, not on the form as combo boxes linked to queries based on the tables. So some more work and hopefully that will fix it.


That link to the cascading combo boxes was a great help.


Thank you for your help.
Di

 

[Alansidman]

You are right about the lookups in tables. Do it in forms. I didn't realize that you had them in your tables.

Read here if you already haven't

http://access.mvps.org/access/lookupfields.htm

Alan