It sounds like you have created a non-updatable query to use as the Record Source of your form. To completely solve the problem, you will need to post the SQL from your query - open the query in Design view, choose SQL View from the View menu, and post what you see here.
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 swordsgen Sent: Monday, January 30, 2006 11:21 PM To: [email protected] Subject: [ms_access] Form will not accept input?? I have created a database in Access 2002. The tables and forms display the information as desired. My problem is, the only way I can input new records is to enter the corresponding info directly into each seperate table. My form that displays the complete record will not accept data entry. Any ideas what I've done wrong??? Yahoo! Groups Links 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/
