 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Form 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. >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 [quoted text clipped - 3 lines] >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.  SignatureJohn 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... > >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 [quoted text clipped - 13 lines] > and ColumnWidths property, to conceal the numeric ID but display the text > ItemNumber. >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. SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.