By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Basing a Field list on another combo box

P: n/a
Hi everybody,

In a form I have 2 combo boxes, X's Row Source Type is a "Filed list"
and Y is based on a "Query". I wan to base X's drop down list on
what's selected from Y's list. Can anyone help me with this?

Thanks for your time and cooperation.


Jun 8 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
If I've understood what you want (show the list of fields that are in a
selected query), use the AfterUpdate event fo the list of queries:

Private Sub cboQuery_AfterUpdate()

Me.cboField.RowSource = Me.lboQuery

End Sub
cboQuery is the list of queries.

cboField is the list of fields in the selected query.
Jun 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.