Search results
-
How to populate fields depending on another field in a form
I have a number of tables and a table listing the linked tables. These are a series of parts tables with data for each type, but I need to list and update/add depending on the type of part (so I may have a type capacitor or type resistor, with fields of value, voltage for capacitors, but value... -
Solved How to show records from one table when no record is in another
I have a query that works fine when there is data in both tables, but not when there is no records in tblTest. SELECT tblQuestions.ID, tblQuestions.Question, tblQuestions.Module FROM tblQuestions, tblTest WHERE (((tblQuestions.ID)<>[tblTest].[lngQuestionID]) AND... -
Solved update the labels of an option group based on a recordset
I have a form with a combo box where users can select a question. each question has a question ID and this filters the Answers table to 4 answers. But I need these 4 answers text field to populate the forms option group buttons labels and Me("Answer" & i).caption where i loops from 1 to 4 does... -