Synchronizing Combo Boxes Code
in [Forms]
|
From: Denise on 20 Jan 2010 10:56 tblObservation Category CategoryID Observation Category tblObservation Questions QuestionID Question Number Question Name CategoryID 1st question - In the Observation Questions I want to combine the Question Number with the Question Name in the table. 2nd question - In a form when I select the Question Number/Name I want the Observation Category to sync. Example: Observation Category Observation Category = Personal Safety Observation Questions Question Number = 01 Question Name = Hard Hats When select "01" populates with "Hard Hats" which populates with "Personal Safety" This is to save have to select from three different combo boxes. Can someone give me some direction? Thanks so much -- Denise B.
From: Douglas J. Steele on 20 Jan 2010 17:29 Why? As is "the QuestionID uniquely identifies the Question Name, why store both?" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Denise" <Denise(a)discussions.microsoft.com> wrote in message news:468DA33C-2334-4482-A075-BD65384E6757(a)microsoft.com... > tblObservation Category > CategoryID > Observation Category > > tblObservation Questions > QuestionID > Question Number > Question Name > CategoryID > > > 1st question - In the Observation Questions I want to combine the Question > Number with the Question Name in the table. > > 2nd question - In a form when I select the Question Number/Name I want the > Observation Category to sync. > > Example: > > Observation Category > Observation Category = Personal Safety > > Observation Questions > Question Number = 01 > Question Name = Hard Hats > > When select "01" populates with "Hard Hats" which populates with "Personal > Safety" > > This is to save have to select from three different combo boxes. > > Can someone give me some direction? > > Thanks so much > -- > Denise B.
From: Denise on 21 Jan 2010 13:58 So what do I do? -- Denise B. "Douglas J. Steele" wrote: > Why? As is "the QuestionID uniquely identifies the Question Name, why store > both?" > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Denise" <Denise(a)discussions.microsoft.com> wrote in message > news:468DA33C-2334-4482-A075-BD65384E6757(a)microsoft.com... > > tblObservation Category > > CategoryID > > Observation Category > > > > tblObservation Questions > > QuestionID > > Question Number > > Question Name > > CategoryID > > > > > > 1st question - In the Observation Questions I want to combine the Question > > Number with the Question Name in the table. > > > > 2nd question - In a form when I select the Question Number/Name I want the > > Observation Category to sync. > > > > Example: > > > > Observation Category > > Observation Category = Personal Safety > > > > Observation Questions > > Question Number = 01 > > Question Name = Hard Hats > > > > When select "01" populates with "Hard Hats" which populates with "Personal > > Safety" > > > > This is to save have to select from three different combo boxes. > > > > Can someone give me some direction? > > > > Thanks so much > > -- > > Denise B. > > > . >
|
Pages: 1 Prev: Field availability dependant on combo box choice Next: List, Combo Box, and or Group Opitions |