Guys, Thanks for the input, made the Query no problem. But have a problem with the combobox Wisser, in Access 97 there is no option to select another query or table for the select record... is this a feature added in 2000 or 2003??
Tried to edit the Properties of the combobox and change the source to the query but will not work, What do I need to change in the properties,, to make this work if possible in 97. Thanks again for your help.. Carl ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
