Inventory Form with Display Lookup
Thank you for taking the time to report an issue.
What's wrong... Please write below.
What I would like to do is have a box on the form that would display the PartDescription when the PartNumber entered into the form matches a PartNumber in the tblItemList.
I don't want the the PartDescription added to the tblInventoryData, I just what a display to confirm that the correct part is added. Can this bedone?
I am trying to create a lookup in the Inventory Table for the MODEL_NUM column. I would like when the user clicks the drop down box they see the choice options as MAN_NAME, MOD_NAME.
Then when someone chooses the option they want it displays the MODEL_NAME in the field. I would actually like it to display a calculated column of MAN_NAME and MODEL_NAME,
When running a query it displays the data that I want. When looking at in datasheet mode it only shows MOD_NAME. It then displays the MOD_NUM.
SELECT MANUFACTURER.MAN_NAME, MODEL.MOD_NAME
FROM MANUFACTURER INNER JOIN MODEL ON MANUFACTURER.MAN_NUM = MODEL.MAN_NUM
ORDER BY MODEL.MOD_NAME, MODEL.MAN_NUM;
For extra information my properties are as follows:
DISPLAY CONTROL: Combo Box
ROW SOURCE TYPE: Table/Query
ROW SOURCE: Code Above
BOUND COLUMN: 2
COLUMN COUNT: 3
COLUMN HEADS: YES
COLUMN WIDTHS: 0";1.6459";1.3646"
I have a lookup column that works fine, but when I try to get the value through vba, I can only get the bound value (a number). I tried doing it the way I would for a combo box: [field].Column(1), but that didn't work. I need the display value so I can use it in a Dlookup function on another table
The second page connects to different table to display a list of warehouse locations that do not have inventory in them (Open locations).
Open locations do not show up in the inventory table until there is inventory in them.
Example XX? for X being the letters and ? being the numbers
I have 3 tables listing of these codes in separate categories and the information of the items they represent.
How do I auto-fill on the form, the additional data from these codes. And is it possible to have this data saved in the shipping table, or does it only display on the form.
I would like to enter inventory records on a form and in a subform display all inventory records already entered for that part number. Basically I would like an add button and a save button but am not understanding how to do this - work with the record data and then save.
Once saved I want this record to be added in a running list of inventory for that part.
I am having trouble with getting the list to display because I am working with entry into the list but am not sure how to setup add record and save record code. How do I work with the dataand then save it and have it pop into the running list of inventory for that part?
[Data from table] [Group Value] [lookup Value]
When I am finished it shows the Group Value. I want it to show the lookup Value
I'm assuming I will have to redesign the form somehow but I'm at a mental block right now.
Is there a way to perform a Dlookup or query that If Forms!PRF!mp1.mp15, find Forms!PRF!q1.q15 (quantity to order) andthat number will be stored in a field in the Inventory table?
Or do I have to re-design the form?
I.e. lookup's are Order, Forname and Surname. On the form I have selected Order and from that want all three to appear under that column.
When I go to datasheet view in Table 2 this column is only displaying the First Name, I can only see the Last Name if I click on the drop down button.
The Lookup Column is working fine in terms of functionality, the issue is with how it's displayed. I need to be able to see both First Name and Last Name without clicking on the drop down.
As I've built queries and reports it continues to only display the first name, which won't work if I need to print anything. My lookup column properties are asfollows: