If you have no queries, but your form is not updatable, then there's probably a "query" (an SQL statement) defined as the Record Source of your form. Open the form in Design view and open the Properties window. Let us know what's in the Record Source property.
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: Tuesday, January 31, 2006 11:00 PM To: [email protected] Subject: [ms_access] Re: Form will not accept input?? First off thanks for the response and help!! Maybe that's part of the problem.........I have no queries. I created the database by importing an excel worksheet, then used a wizard to seperate the data into four tables. I then created the form using another wizard to combine all the data on one form, expecting to be able to use the form to input new records. As it is, I have to enter new data into each seperate table. The form displays the data (old and new) fine, if I go to new record and try to input new info the computer just beeps at me. Thanks again for your help --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 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/
