how to create a combo box in access to look up records from a pre.

H

hotrains2002

I do a filter by Form for CD Group and I want it to display the records of
the name of Cd Just from that CD Group

Example
CD Group Mormon Tabernacle Chior
Name of CD's just from that group not from all the records

Please email me at [email protected]
 
S

Sprinks

First of all, Hotrains, answers to this Newsgroup are posted HERE, so that
all members can benefit. I suggest you read the suggested Netiquette rules
under Help.

Re: your problem--you basically want to set the second combo box' Row
Source property based on the selection from the first in the AfterUpdate
event of the first. The Row Source property assignment must evaluate to a
valid string. Something like:

MySecondComboBox.RowSource = "Select <fieldlist> From <table> Where
[YourFieldName] = " & MyFirstComboBox

Hope that helps.

Sprinks
 
Top