If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Form format issue
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] |
#3
|
|||
|
|||
Form format issue
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] |
#4
|
|||
|
|||
Form format issue
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] |
Thread Tools | |
Display Modes | |
|
|