Search results

Thank you all so much for your help, I finally got it to work. For reference, I'll put the whole code here: Option Compare Database Private Sub btnPlatformNext_Click() Dim intPlatform As Integer cmbPlatform.SetFocus intPlatform = cmbPlatform.Value Call...

Thanks for your responses. @boblarson: The code I posted is what I have, so I'm guessing I don't have the lookups defined at table level. I'm not sure what those look like, do you mind explaining it further? @BobMcClellen: I don't foresee any records being deleted, but just in case, do you...

Thanks for your response, Bob L. I tried it with various versions of the double quotes, but each time I got "Run-time error '3075': Syntax error (missing operator) in query expression ..." This might be because it's an integer (in the Platforms table I have each platformName with a...

Thanks so much for your answer, Bob. I updated the function by adding the step for with finding the last row (rowID) and changed the strSQL to UPDATE. Private Sub CreatePlatform(plat As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim rowID As Long Set db =...

To give you some background, what I'm trying to do is create an interface that lets people create game scenarios. Through various screens (forms) they can select different options. These are then saved in a final tblScenario. I've been able to let them fill out txt boxes (Scenario Name, etc.)...