By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Retrieving information from tables

P: n/a
Hi All,

I have a form where a user has to pick up a SuburbName from a ComboBox (the
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 two
text boxes with the corresponding State and Postcode

Any ideas how to do this?

Regards,
Nicolae
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

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" <no****@please.cxm> wrote in message
news:40********@duster.adelaide.on.net...
Hi All,

I have a form where a user has to pick up a SuburbName from a ComboBox (the 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 two text boxes with the corresponding State and Postcode

Any ideas how to do this?

Regards,
Nicolae

Nov 13 '05 #2

P: n/a
Thank you Larry, it worked great
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.