Good morning everyone!
I am trying to change some code around a bit in order to work without 2 previous parameters. The main idea is the code has to check if a tuple is already in the database. Here is the old version (with the two values I don't want):
Set rstTable1 = db.OpenRecordset("Parallel_Regression", dbOpenTable)
rstTable1.Index = "PrimaryKey"
rstTable1.Seek "=", [Forms]![Parallel_Regression_Form]![Frame34], [Forms]![Parallel_Regression_Form]![Frame46], [Forms]![Parallel_Regression_Form]![Combo70], [Forms]![Parallel_Regression_Form]![Release]
The values in red are the ones that I have to remove. However, because "Combo 70" is a text field and NOT a number field the Seek function gets an error. Those two fields are also primary keys which causes more trouble since Combo 70 is NOT a primary key.
Anyone know how I can fix this??? THANKS, this board is great!
-Tim
I am trying to change some code around a bit in order to work without 2 previous parameters. The main idea is the code has to check if a tuple is already in the database. Here is the old version (with the two values I don't want):
Set rstTable1 = db.OpenRecordset("Parallel_Regression", dbOpenTable)
rstTable1.Index = "PrimaryKey"
rstTable1.Seek "=", [Forms]![Parallel_Regression_Form]![Frame34], [Forms]![Parallel_Regression_Form]![Frame46], [Forms]![Parallel_Regression_Form]![Combo70], [Forms]![Parallel_Regression_Form]![Release]
The values in red are the ones that I have to remove. However, because "Combo 70" is a text field and NOT a number field the Seek function gets an error. Those two fields are also primary keys which causes more trouble since Combo 70 is NOT a primary key.
Anyone know how I can fix this??? THANKS, this board is great!
-Tim
