Form format issue

I have a sub form that opens up from a master form. Data such as issue
details and master form Id fill in on the sub form. Yet when I pull the item
number for some reason it puts in a number like 2227 when the correct number
should be 1048285-w.

How do I get it to pull the field correctly. I do not have any other issues
with the other fields.

On Wed, 9 Apr 2008 20:35:00 -0700, Rpettis31
wrote:

I have a sub form that opens up from a master form. Data such as issue
details and master form Id fill in on the sub form. Yet when I pull the item
number for some reason it puts in a number like 2227 when the correct number
should be 1048285-w.

How do I get it to pull the field correctly. I do not have any other issues
with the other fields.

My guess is that you are yet another victim of Microsoft's "Lookup Wizard"
misfeature. Is this field perchance a Lookup Field in the master table? If so,
it actually CONTAINS the numeric ID; it only *appears* to contain the text
value.

Since you don't say how you're "pulling" the item number it's hard to say for
sure, but it may be that you need a Combo Box with an appropriate rowsource
and ColumnWidths property, to conceal the numeric ID but display the text
ItemNumber.
--

John W. Vinson [MVP]

I am pulling it by =forms!CustSvcIssue!ItemNumber which is a field on the
master that is a combo box that looks up the item number on another table
called item master. So basically the custsvcissue has a field called Item
Number, the user typers in the Item number which is a combo box that looks up
the items number from the item master table. When the selection is filled
the description is also pulled...


"John W. Vinson" wrote:

On Wed, 9 Apr 2008 20:35:00 -0700, Rpettis31
wrote:

I have a sub form that opens up from a master form. Data such as issue
details and master form Id fill in on the sub form. Yet when I pull the item
number for some reason it puts in a number like 2227 when the correct number
should be 1048285-w.

How do I get it to pull the field correctly. I do not have any other issues
with the other fields.

My guess is that you are yet another victim of Microsoft's "Lookup Wizard"
misfeature. Is this field perchance a Lookup Field in the master table? If so,
it actually CONTAINS the numeric ID; it only *appears* to contain the text
value.

Since you don't say how you're "pulling" the item number it's hard to say for
sure, but it may be that you need a Combo Box with an appropriate rowsource
and ColumnWidths property, to conceal the numeric ID but display the text
ItemNumber.
--

John W. Vinson [MVP]

On Thu, 10 Apr 2008 04:31:01 -0700, Rpettis31
wrote:

I am pulling it by =forms!CustSvcIssue!ItemNumber which is a field on the
master that is a combo box that looks up the item number on another table
called item master. So basically the custsvcissue has a field called Item
Number, the user typers in the Item number which is a combo box that looks up
the items number from the item master table. When the selection is filled
the description is also pulled...

The combo box on CustSvcIssue undoubtedly has the numeric ID as its bound
column, therefore you're pulling that value. My question would be - do you
really need to display the description here? Normally in this circumstance one
would use a mainform based on the customer service issue (displaying the item
description in the combo box, while storing the numeric ID); and a Subform for
the child table. It would not then be necessary to redisplay the description,
since it's right there already on the mainform!

If you wish to do this anyway, you can pull the description column from the
combo box rather than the bound column by using

=forms!CustSvcIssue!ItemNumber.Column(n)

where n is the zero based index of the column you want to see - e.g. (1) to
display the second field in the combo's row source query.
--

John W. Vinson [MVP]