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

Bound combo to control another combo

P: n/a
D
Book inventory. Access 2K.

I'm trying to let a user choose a book title from one combo box, then a book
number for that book title from another combo box. I can filter the book
number combo with an unbound book title combo, but I'd like the user to see
both the title and number when returning to the record. I've seen it done -
just can't remember where. Anyone guide me to a solution?

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"D" <da**********@hotmail.com> wrote in message news:<whXhb.5611$Pe5.1722@edtnps84>...
Book inventory. Access 2K.

I'm trying to let a user choose a book title from one combo box, then a book
number for that book title from another combo box. I can filter the book
number combo with an unbound book title combo, but I'd like the user to see
both the title and number when returning to the record. I've seen it done -
just can't remember where. Anyone guide me to a solution?

Thanks in advance.


Okay, if you want to see the title and the number and they're both in
columns in the combobox, you can create a textbox that has as its
rowsource

Me.MyCombo.Columns(x) where x is the zero-based column number (So
it'll be one less than the ordinal position.) Hope that's what you
meant...
Nov 12 '05 #2

P: n/a
D
Echoing the column is a good idea, but I'm getting the #Name? error.

When using the property sheet, it changes this
=BookID.Columns(3) into the bracketed =[BookID].[Columns](3)

I can debug the value of this column successfully with an onCurrent
procedure.

What's up?

D

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf*************************@posting.google.co m...
"D" <da**********@hotmail.com> wrote in message

news:<whXhb.5611$Pe5.1722@edtnps84>...
Book inventory. Access 2K.

I'm trying to let a user choose a book title from one combo box, then a book number for that book title from another combo box. I can filter the book
number combo with an unbound book title combo, but I'd like the user to see both the title and number when returning to the record. I've seen it done - just can't remember where. Anyone guide me to a solution?

Thanks in advance.


Okay, if you want to see the title and the number and they're both in
columns in the combobox, you can create a textbox that has as its
rowsource

Me.MyCombo.Columns(x) where x is the zero-based column number (So
it'll be one less than the ordinal position.) Hope that's what you
meant...

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.