| re: Retrieving information from tables
Me!txtState = Me!cboStuff.Column(2)
Me!txtPostcode = Me!cboStuff.Column(3)
provided, of course, that those are the names of your Controls.
Larry Linson
Microsoft Access MVP
"Nicolae Fieraru" <nospam@please.cxm> wrote in message
news:40da41f1$1@duster.adelaide.on.net...[color=blue]
> Hi All,
>
> I have a form where a user has to pick up a SuburbName from a ComboBox[/color]
(the[color=blue]
> combobox displays more fields)
> The combobox contains data from a query, called qrySelectSuburb
> This query has the following fields: SuburbID, SuburbName, State and
> PostCode fields
> I want to build an event which after update of the ComboBox will fill in[/color]
two[color=blue]
> text boxes with the corresponding State and Postcode
>
> Any ideas how to do this?
>
> Regards,
> Nicolae
>
>[/color]
| 
