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

combobox contents from db

P: n/a
Hi,

I wish to have a couple of comboboxes, one populated with all tables (got
this working) and the other will update with the fields of whatever table is
selected in the first combobox.

cboTables has rowsource set as a query 'show_tables' (showing all tables)
so far for cboFields rowsource I have variants of 'select * from
me!cmbTables.value where 1=2' - but I don't really know what I'm doing here,
so it clearly doesn't work.

Can anyone give any pointers?

Also, in cboTables I have 'cmbFields.Requery' as an event for afterupdate,
is this ok?

Many thanks!
Chris
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"C L Humphreys" <cl*********@toofgib.moc> wrote in message
news:bk**********@ucsnew1.ncl.ac.uk...
Also, in cboTables I have 'cmbFields.Requery' as an event for afterupdate,
is this ok?


Please ignore the fact I'm mixing cbo and cmb for the combobox names, that's
just a typo!

Chris
Nov 12 '05 #2

P: n/a

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:nc********************************@4ax.com...

http://www.mvps.org/access/forms/frm0028.htm


Thanks, but I still can't get it to work. I need the second combobox to
show the field names of the table selected in the first. It would work fine
if I wanted the fields themselves, but that isn't the problem.

It may help if I could display the field names as a single column?

Thanks again,
Chris
Nov 12 '05 #3

P: n/a
"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:ab********************************@4ax.com...
On Fri, 19 Sep 2003 08:58:15 +0100, "C L Humphreys"
<cl*********@toofgib.moc> wrote:
"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:nc********************************@4ax.com.. .
http://www.mvps.org/access/forms/frm0028.htm
Thanks, but I still can't get it to work. I need the second combobox to
show the field names of the table selected in the first. It would work

fineif I wanted the fields themselves, but that isn't the problem.
It may help if I could display the field names as a single column?


Assume the first combobox is named "cboQueryToUse", and
the second is named "cboFieldToUse".

<snipped>

Great, thanks a lot.

Chris
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.