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 <*> 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/
