Design view, properties reveals the following: SELECT CNTRLS.DATE, CNTRLS.CONTROL, CNTRLS.TYPE, CNTRLS.PAYOR, CNTRLS.CNTRL7, PKUPS.[PU NAME], PKUPS.[PU STREET], PKUPS.[PU ZIP], PKUPS.[PU PHONE], PKUPS.[PU MAP], DLVS.[DLV NAME], DLVS.[DLV STREET], DLVS.[DLV ZIP], DLVS.[DLV PHONE], DLVS.[DLV MAP], CNTRLS.[# PCS], CNTRLS.WEIGHT, CNTRLS.[WAIT TIME], CNTRLS.AMOUNT FROM PKUPS INNER JOIN (DLVS INNER JOIN CNTRLS ON DLVS.ID=CNTRLS.DLVS_ID) ON PKUPS.ID=CNTRLS.PKUPS_ID;
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
