Hi All This one has me pulling my hair out, not that there is much left I have a combo box that currently looks up to a table of organisation types. This contains fields and values like Org ID Type 1 GP Practice 2 Hospital 3 Area Health 4 Pharmacy 5 Council Office
etc I want to have combo box on a form so that a user can choose the organisation type which gets passed to a query and shows the contacts for a particular organisation type BUT I want to have it so that the user has 3 choices - 1: GP Practice, 2: Other Organisations (which encompasses all of the other organisations listed above) and 3: All Organisations (which is all of the organisation types) I have tried various combo boxes to get this to work but no luck Can anyone suggest how I do this please? TIA Julian F ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h3tj5m6/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124018890/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
