binding textbox to combo

[Parasyke]

Anyone with know the best way to do this one?
I have a form that is unbound (i.e. in its properties the form itself
is blank for the datasource). I have a combobox named "cboDBName" and a
textbox named "txtPathName". The combobox has as its datasource the
following:

SELECT [tblDatabases].[DBName] FROM tblDatabases ORDER BY
[tblDatabases].[DBName];

The table is simply a two column one with the database name (column 1)
and the database (path column 2).

I want the database path to appear in the textbox when the combobox
receives its choice. I used the following in the after_update code for
the combobox and this doesn't work:

Private Sub cboDBName_AfterUpdate()
Me.txtPathName = Me.cboDBName.Column(2)
End Sub

'Any ideas? thanks!

[anon]

On 17 Apr 2006 10:56:52 -0700, "Parasyke" <kr************@yahoo.com>
wrote:

Anyone with know the best way to do this one?
I have a form that is unbound (i.e. in its properties the form itself
is blank for the datasource). I have a combobox named "cboDBName" and a
textbox named "txtPathName". The combobox has as its datasource the
following:

SELECT [tblDatabases].[DBName] FROM tblDatabases ORDER BY
[tblDatabases].[DBName];

The table is simply a two column one with the database name (column 1)
and the database (path column 2).

I want the database path to appear in the textbox when the combobox
receives its choice. I used the following in the after_update code for
the combobox and this doesn't work:

Private Sub cboDBName_AfterUpdate()
Me.txtPathName = Me.cboDBName.Column(2)
End Sub

combo box columns are zero based. Try .Column(1)

Jim

[Parasyke]

I looked at the properties for my combobox and the bound column is set
to 1 which gives me the correct database name, but I changed it to 0
and got an error. changing the Column(2) in the textbox to Column(1)
didn't change anything.

[Ron2005]

And select both the db name AND the path in your SELECT statement.

[Ron2005]

If the fields are retrevied in DBName and then Path, then the lengths
would be 1,0 and # columns = 1 and bound probably # 1

[Parasyke]

Now I get a -1 on all 20 lines of my dropdown on the combo PLUS a
break/debug on this code:

Private Sub cboDBName_AfterUpdate()
Me.txtPathName = Me.cboDBName.Column(1)
End Sub

[Jeff]

Keep it simple. Put this in the ControlSource of the text box.

= cboDBName.Column(2)

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"Parasyke" <kr************@yahoo.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Anyone with know the best way to do this one?
I have a form that is unbound (i.e. in its properties the form itself
is blank for the datasource). I have a combobox named "cboDBName" and a
textbox named "txtPathName". The combobox has as its datasource the
following:

SELECT [tblDatabases].[DBName] FROM tblDatabases ORDER BY
[tblDatabases].[DBName];

The table is simply a two column one with the database name (column 1)
and the database (path column 2).

I want the database path to appear in the textbox when the combobox
receives its choice. I used the following in the after_update code for
the combobox and this doesn't work:

Private Sub cboDBName_AfterUpdate()
Me.txtPathName = Me.cboDBName.Column(2)
End Sub

'Any ideas? thanks!

[Ron2005]

If it still does not work, please post the actual sql that you have as
the record source for the combo, because all of our suggestions are
based on assumptions about the sequence of fields in that query.

[Ron2005]

The binding and length are counts that based on the first field being
addressed by 1. But the column is 0 based and the first field is
addressed by using 0.

[Parasyke]

This works ...thanks!