Search Form 20 Questions - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Form 20 Questions

Walter Hamilton

4 years ago

I have subform with a combo box that needs to be filtered by the value of 1 - 3 combo boxes on the main form. I've tried with the query like the video shows and can't seem to get it to work. The values need to match the values in the main form combo boxes if they aren't Null. Can I construct an SQL statement to be the datasource for the sub form's combo box?

	Richard Rost @Reply 4 years ago
Can you post a screen shot so I can see what you've got?

	Richard Rost @Reply 4 years ago
The answer is "yes." I just need more info.

	Walter Hamilton OP @Reply 4 years ago

	Walter Hamilton OP @Reply 4 years ago

Walter Hamilton OP @Reply

4 years ago

Richard - I've posted a screenshot of the Row Source query for the Customer POC combo box on the subform. This combo box needs to be filter according to the values in the following three combo boxes in the main form:

Major Command named [MajorCommand_ID]
Component Command [ComponentCommand_ID]
Command [Command_ID]

These three combo boxes are filtered from left to right so you will always have MajorCommand_ID if you have ComponentCommand_ID and Command_ID.

Likewise, you will always have ComponentCommand_ID if you have Command_ID.

I was trying to do it with the query as the Rowsoure, but I'm fine if it needs to be in VBA. I just don't know how to formulate everything for the row source.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View