Combo box display
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I have a combo box that is populated with 3 fields from a query. The fields
are locality, state and postcode. The combo box shows all 3 fields sorted
by locality and state.
When clicking on the required locality, state and post code three text
fields are populated using cboName.column(0) for locality etc.
If there are two or more localities with the same locality name but
different state and post code the system only returns the first locality
regardless of which element is clicked. Any ideas?
Regards
Grant Meyers
.
Relevant Pages
- Re: Combo box display
... > fields are locality, state and postcode. ... > When clicking on the required locality, state and post code three text ... > locality regardless of which element is clicked. ... is in the bound column. ...
(microsoft.public.access.formscoding) - RE: How do I have postcodes and states entered automatically?
... you want to use the locality field to fill the ... My suggestion is that you use the DLookup function to retrieve the data from ... > Locality, State and postcode. ... > course based on the Post Office table showing each of these)? ...
(microsoft.public.access.forms) - Re: Check Postcode and suburb
... you get a different localities with the same postcode and different postcodes for the same locality. ... Create a combined PostcodeLocality column and sort by this. ... they are correct using the post offices post code with suburb. ...
(microsoft.public.excel.programming) - Re: Check Postcode and suburb
... different postcodes for the same locality. ... Create a combined PostcodeLocality column and sort by this. ... the combined Postcode Locality. ... they are correct using the post offices post code with suburb. ...
(microsoft.public.excel.programming) - How do I have postcodes and states entered automatically?
... Locality, State and postcode. ... fill in the postcode and state in the appropriate form fields based ... course based on the Post Office table showing each of these)? ...
(microsoft.public.access.forms) |
|
