Connecting Tech Pros Worldwide Forums | Help | Site Map

Filter one combo box based on another

Cassie Pennington
Guest
 
Posts: n/a
#1: Nov 13 '05
I have tried to filter one combo box based on a selection in another
combo box, by using the following sample code:
tblfield=forms![formname]![fieldname]. However, the combobox only
seems to recognise the first record, not the current record in order
to limit the list? Any suggestions?

Thanks in anticipation

Pieter Linden
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Filter one combo box based on another


cassie.dowling@btinternet.com (Cassie Pennington) wrote in message news:<473882f8.0409191028.350e3c68@posting.google. com>...[color=blue]
> I have tried to filter one combo box based on a selection in another
> combo box, by using the following sample code:
> tblfield=forms![formname]![fieldname]. However, the combobox only
> seems to recognise the first record, not the current record in order
> to limit the list? Any suggestions?
>
> Thanks in anticipation[/color]

Read this article:
http://www.mvps.org/access/forms/frm0028.htm
Closed Thread