Access Front End Form/Subform issues with SQL Tables ceggy 06.12.2005 15:31:04 I recently completed a project in Access that uses Froms and Subforms without any issues. My boss now wants the data to sit in a SQL dB and still use the Access forms to add and view the data. I moved the data to SQL and set links up through ODBC in the Access front end. I have an order entry form that contains the customers information (name, address, etc) for this order and a subform that contains the line items for this order. This worked fine when the data was stored in Access, now that the data is sitting in SQL I am having two issues. 1) After I enter the customer information in main form and then enter into the subform all my fields on the main form display #Delete, yet when I look directly at the table all the information I entered was saved to table just like in Access. I know Access saves the data when moving from the main form to the subform. I never had this issues when I was saving the data in Access. I have tried me.refresh in Form_AfterUpdate() with no success. 2) My sub form is a Continuous Form. Again no problems when it was just Access. Now when I enter the line items for an order, regardless that I use different item numbers for each line item and the amount of line items entered, all the line items are saved to the table as the first line item entered for this order. I am using Access 2003, MS-SQL 2000 and have the latest Jet engine loaded on my PC. Any help is greatly appreciated.

Re: Access Front End Form/Subform issues with SQL Tables Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 06.12.2005 16:10:26 hi, ceggy wrote: [Quoted Text] > 1) After I enter the customer information in main form and then enter into > the subform all my fields on the main form display #Delete, yet when I look > directly at the table all the information I entered was saved to table just > like in Access. Has your table a primary key? Don't use floats or any other unprecise datatype as primary key. Add a field of type TIMESTAMP and relink your tables. mfG --> stefan <--