Combo Box problem

Bruce Rodtnick · Nov 21, 2003

I have a combo box with a row source from a table (TapeName), using an ID (autonumber) and a name (text), so I have two columns in the query.  I've set the column count to 2 and the column widths to 0";5".  The bound column is 1.

The control source is to a second table (Tapes) and is a text field.  I'm using DLookup to populate four other combo & text boxes which ends up in the and that works fine.  A text box is populated by the ID and in the new table, the ID is a number field.

But when I run the form I get an error:
The value you entered isn't valid for this field.
For example, you may have entered text into a numeric field or a number that is larger than the fieldsize setting permits.

When I change the column widths to 1";5" I don't have the problem, but then the ID is in the combo box and I don't want that.

Why is this happening?

I'm running 2000

Bruce Rodtnick

John Vinson · Nov 21, 2003

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

Please turn off HTML posting. Many newsreaders can't handle it, and
many news readers don't like it. (I'll usually delete messages that
just have an HTML icon when I bring up the message, unread, but on a
whim I opened it).

I have a combo box with a row source from a table (TapeName), using an
ID (autonumber) and a name (text), so I have two columns in the query. 
I've set the column count to 2 and the column widths to 0";5".  The
bound column is 1.

sounds good...

The control source is to a second table (Tapes) and is a text field. 
I'm using DLookup to populate four other combo & text boxes which ends
up in the and that works fine.  A text box is populated by the ID
and in the new table, the ID is a number field.

Now wait a minute. Three lines up you say the control source is a text
field; here you say the ID number is a number field. Which?

But when I run the form I get an error:
 The value you entered isn't valid for this field.

It sounds like you're putting a number into a text field.

Could you post the actual DLookUp expressions? Are you using the
Column() property of the combo box - and taking into account that it
is zero based, so that (2) is the third column of the rowsource query?

Bruce Rodtnick · Nov 21, 2003

The info that shows up in the combo box is a text field.  I don't know what you're talking about with the column().  Could you explain that?

Here's my Dlookup code:

    Dim strFilter As String
 
    ' Evaluate filter before it's passed to DLookup function.
    strFilter = "TapeID = " & Me!cboTapeName
 
    ' Look up product's unit price and assign it to UnitPrice control.
    Me!cboTapeName = DLookup("TapeName", "TapeNames", strFilter)
    Me!cboProducer = DLookup("Producer", "TapeNames", strFilter)
    Me!cboVideographer = DLookup("Videographer", "TapeNames", strFilter)
    Me!DateShot = DLookup("DateShot", "TapeNames", strFilter)
    Me!Notes = DLookup("Notes", "TapeNames", strFilter)
    Me!txtTapeID = DLookup("TapeID", "TapeNames", strFilter)

B
 

John Vinson wrote: On Thu, 20 Nov 2003 23:36:36 -0600, Bruce Rodtnick
<[email protected]> wrote:

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

Please turn off HTML posting. Many newsreaders can't handle it, and
many news readers don't like it. (I'll usually delete messages that
just have an HTML icon when I bring up the message, unread, but on a
whim I opened it).

I have a combo box with a row source from a table (TapeName), using an
ID (autonumber) and a name (text), so I have two columns in the query.&nbsp;
I've set the column count to 2 and the column widths to 0";5".&nbsp; The
bound column is 1.

sounds good...

The control source is to a second table (Tapes) and is a text field.&nbsp;
I'm using DLookup to populate four other combo &amp; text boxes which ends
up in the and that works fine.&nbsp; A text box is populated by the ID
and in the new table, the ID is a number field.

Now wait a minute. Three lines up you say the control source is a text
field; here you say the ID number is a number field. Which?

But when I run the form I get an error:
 The value you entered isn't valid for this field.

It sounds like you're putting a number into a text field.

Could you post the actual DLookUp expressions? Are you using the
Column() property of the combo box - and taking into account that it
is zero based, so that (2) is the third column of the rowsource query?

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John Vinson · Nov 21, 2003

The info that shows up in the combo box is a text field.  I don't
know what you're talking about with the column().  Could you explain
that?
Here's my Dlookup code:
    Dim strFilter As String

Please post this in a readable form and I'll try to help.

Bruce Rodtnick · Nov 23, 2003

Let me start over.

I have a combo box with a row source from a table (cboTapeName).  The combo box has a row source from a table, TapesNames, with two columns, TapeID (autonumber) and TapeName (text)  I've set the column count to 2 and the column widths to 0";5".  The bound column is 1.

I'm using DLookup to populate four other combo & text boxes:

Private Sub cboTapeName_AfterUpdate()
Dim strFilter As String
 
    ' Evaluate filter before it's passed to DLookup function.
    strFilter = "TapeID = " & Me!cboTapeName
 
    ' Look up product's unit price and assign it to UnitPrice control.
    Me!cboTapeName = DLookup("TapeName", "TapeNames", strFilter)
    Me!cboProducer = DLookup("Producer", "TapeNames", strFilter)
    Me!cboVideographer = DLookup("Videographer", "TapeNames", strFilter)
    Me!DateShot = DLookup("DateShot", "TapeNames", strFilter)
    Me!Notes = DLookup("Notes", "TapeNames", strFilter)
    Me!txtTapeID = DLookup("TapeID", "TapeNames", strFilter)
 

But when I run the form I get an error:
The value you entered isn't valid for this field.
For example, you may have entered text into a numeric field or a number that is larger than the fieldsize setting permits.

When I change the column widths of the combo box (cboTapeName) to 1";5" I don't have the problem, but then the ID shows in the combo box and I don't want that.

Why is this happening?

I'm running 2000

Bruce Rodtnick
 

John Vinson wrote: On Fri, 21 Nov 2003 06:54:59 -0600, Bruce Rodtnick
<[email protected]> wrote:

The info that shows up in the combo box is a text field.&nbsp; I don't
know what you're talking about with the column().&nbsp; Could you explain
that?
Here's my Dlookup code:
&nbsp;&nbsp;&nbsp; Dim strFilter As String

Please post this in a readable form and I'll try to help.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John Vinson · Nov 23, 2003

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

Bruce, I'm sorry. But I use Agent to read newsgroup messages. It shows
your message as a small icon indicating that it is an HTML file.

I could read it with some hassle... BUT I WON'T.

Please start a new thread if you want someone more tolerant of HTML to
reply, or post in text rather than in HTML, because I simply don't
want to take the time to open a web browser for messages with text
content.

Bruce Rodtnick · Nov 23, 2003

Sorry, I thought I WAS sending in text form. I hope I've fixed it now.

B