THANKS!!!!!!!! The form will now accept input!!! But now I have a new question.
Is it possible to update (add new records) to a lookup table from within the form (on the fly as it were), or do I have to add new customer info to the respective tables seperately and then add new records? Again, Thanks for your help!!!! Jim --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
