Synchronizing Combo Boxes Code

[Denise]

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

 

[Douglas J. Steele]

Why? As is "the QuestionID uniquely identifies the Question Name, why store
both?"

 

[Denise]

So what do I do?
--
Denise B.

Why? As is "the QuestionID uniquely identifies the Question Name, why store
both?"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)





.