Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Combo Box Choices (New)

Status
Not open for further replies.
dannyocean

dannyocean

Technical User
Jan 26, 2001
136
US
Hello All,

I have a form and I am trying to tie all the combo boxes criteria to the auditor field. This will allow the database to have better flexibility and be used across the enterprise.

If the auditor is a corporate employee e does not belong to a specific service center. Some employees do belong to a specific service center.


So I am needing to tie the service center choices to the auditor table. this table has the auditor id and service center. Corporate auditors are listed as CP for the service center. I need this to recognized as "*" by the query tht supports the service center combo box.

Any help would be appreciated.

Danny
 
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
203
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
185
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
750
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question
Make second combo box display records dependant on selection from first combo box 1
Replies
2
Views
139
dhookom
dhookom
rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
489
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top