Daniel- If you include the person (Students?) table in the form Record Source, when you set the Foreign Key (StudentID?) from the Combo Box, Access should auto-lookup the address data for you. If that's not enough info, please post the SQL from you Record Source and a general layout of your tables.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Sent: Monday, December 12, 2005 6:19 PM To: [email protected] Subject: [ms_access] Form help request Doing an Access project for my university course and im having this problem. Making a form based on a qry from several tables, i want to click the name of the person from a combo box and have the address details auto complete on the fields in the form. all thats happening now is that the name comes up but noting else anywhere. thanks. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/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/
