OK. Your relationships are: DLVS -> CNTRLS
PKUPS -> CNTRLS To be able to insert new rows into CNTRLS, the query must contain both foreign keys, and they must be available on the form to pick the related DLVS and PKUPS. Try this: SELECT CNTRLS.PKUPS_ID, CNTRLS.DLVS_ID, 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; You can start a new query, choose SQL View from the View menu, replace all text in the window with what you see above, and switch back to Design view. Save the query and give it a name and use that as your Record Source. 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: Wednesday, February 01, 2006 10:30 AM To: [email protected] Subject: [ms_access] Re: Form will not accept input?? 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 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/
