combobox contents from db

[C L Humphreys]

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.va lue 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.Requ ery' as an event for afterupdate,
is this ok?

Many thanks!
Chris

[C L Humphreys]

Re: combobox contents from db


"C L Humphreys" <clhumphreys@to ofgib.moc> wrote in message
news:bkc0g7$96p $1@ucsnew1.ncl. ac.uk...
[color=blue]
> Also, in cboTables I have 'cmbFields.Requ ery' as an event for afterupdate,
> is this ok?[/color]

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

Chris

[C L Humphreys]

Re: combobox contents from db


"Chuck Grimsby" <c.grimsby@worl dnet.att.net.in valid> wrote in message
news:ncekmvkaqt kdvlicltmc7d1s0 tcut9786t@4ax.c om...[color=blue]
>
> http://www.mvps.org/access/forms/frm0028.htm
>[/color]

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

[C L Humphreys]

Re: combobox contents from db

"Chuck Grimsby" <c.grimsby@worl dnet.att.net.in valid> wrote in message
news:abjlmvoshs agbv4phv28ggqrv 0vvv3ocn9@4ax.c om...[color=blue]
> On Fri, 19 Sep 2003 08:58:15 +0100, "C L Humphreys"
> <clhumphreys@to ofgib.moc> wrote:[color=green]
> >"Chuck Grimsby" <c.grimsby@worl dnet.att.net.in valid> wrote in message
> >news:ncekmvkaq tkdvlicltmc7d1s 0tcut9786t@4ax. com...[color=darkred]
> >> http://www.mvps.org/access/forms/frm0028.htm[/color][/color]
>[color=green]
> >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[/color][/color]
fine[color=blue][color=green]
> >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?[/color]
>
> Assume the first combobox is named "cboQueryToUse" , and
> the second is named "cboFieldToUse" .[/color]
<snipped>

Great, thanks a lot.

Chris