access vba - Open a specified form based on a button in a continuous form -
I have a constant form with each button for each record, I want to open another form with that button Where a specified segment (id = "123") edit : I found out that ID still pulls up until I do not query data from any other table . So I can use the table where the id remains, but if I add it to another table, then TaskID value gets taped. Any idea here is the code: Constant form strWhere = "[TaskID] error on private sub btnOpenForm_Click () Goto btnOpenForm_Click_Err dim strWhere string 'Assign as TaskID =" & Amp; My [TaskID] DoCmd.OpenForm "frmDBAFix" ,,, strWhere btnOpenForm_Click_Exit:. Exit sub btnOpenForm_Click_Err: MsgBox error $ resume btnOpenForm_Click_Exit End Sub Before the data table Appearance was visible as the tables were connected through the foreign key and there was no data in the table 2. Not sure why this also preventing textfields from appearing ... but I will leave it alone. Thanks