Search results

I'm not sure exactly what you are asking but you might try using some lookup fields. For example in your TypeTest table you could add an autonumber field for the primary key. Then, in design view, change the IDTypeTest field in the Test table to a lookup and choose to display the IDTypeTest and...

I don't see any problems with that line of code but here are some suggestions: 1.If ProductId is a text field you need to change your sql to "update tblProduct set chosen = True where ProductID = '" & cmbProductId & "'" 2.Try adding the optional dbFailOnError to your command "update...