Inserting Record

[aggieval]

I have just converted an Access Database to SQL Server still using Access as the front end. I am having issues with a form that before the conversion workind fine. The form runs from a query that links the Individual Table with the IndCourse table. They are linked by Ind#. This is the primary on the Individual table. The form works fine if you are adding an Individual to a course where the individual already exists in the database, but if it is a new individual I am getting a time-out error. I am already inserting this individual into the database and selecting that ind#. Here's the kicker, If after selecting new individual and inserting new ind into table, if I select the record select bar on the left, the record saves fine, otherwise I get the error. I have tried in code telling it to select the record and then save, but I am still getting the error.

Any suggesting would be incredibly helpful. I feel like I am beating my head against a brick wall now.

Tracy

 

[Rolliee]

Forget the form. Your data is in a recordset. That recordset is from a table. Put the data in the table and requery the form or subform. It takes a lot less protocol to do this - and it will work out faster.

rollie@bwsys.net