Little_Anj
Registered User.
- Local time
- Tomorrow, 02:06
- Joined
- Dec 14, 2012
- Messages
- 25
Hi, I know there are quite a few threads about combo boxes and continuous forms so I will apologise in advance if this is already solved somewhere else.
(I will take a good link to a post as a solution).
I have a continuous form (works great), with two combo boxes that navigate (rather than limit/ filter the list) to the desired selection.
One for suburb and one for postcode.
They work great (ish)!
I have expanded the select criteria for the suburb to include postcode as some suburb names are used in more than one state. (I do not want to have to select a state, then suburb).
I changed the column count to see the postcode next to the suburb, however when the selection is made only the first instance is selected.
Example.
Epping 2121
Epping 3076
If I chose Epping 3076, Epping 2121 is selected and the continuous form navigates to that suburb (rather than the one with 3076).
Can I change this so that I can still search by postcode, or search by suburb and have the form navigate to the corrected suburb postcode combination?
(I will take a good link to a post as a solution).
I have a continuous form (works great), with two combo boxes that navigate (rather than limit/ filter the list) to the desired selection.
One for suburb and one for postcode.
They work great (ish)!
I have expanded the select criteria for the suburb to include postcode as some suburb names are used in more than one state. (I do not want to have to select a state, then suburb).
I changed the column count to see the postcode next to the suburb, however when the selection is made only the first instance is selected.
Example.
Epping 2121
Epping 3076
If I chose Epping 3076, Epping 2121 is selected and the continuous form navigates to that suburb (rather than the one with 3076).
Can I change this so that I can still search by postcode, or search by suburb and have the form navigate to the corrected suburb postcode combination?