Joe- If you open the query from the database window, can you edit the data there? If you can, then there's a problem with your form. If not (which is what I suspect), then you haven't created an updatable query. Switch to Design view of the query, choose SQL View from the View menu, and paste what you see into a reply.
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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Monday, November 14, 2005 1:51 PM To: ms_access@yahoogroups.com Subject: [ms_access] ?? on Editing data form a query on a form? Hi, Would anyone know why, I have a form which chooses a record based on a choice froma list box. the record is a query of two tables(Client & ClientData). When the form opens it doesn't allow any data to be edited? It would be nice, except I want the form to edit the data.. Thanks Joe ------------------------ 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/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/