I am attempting to create a mulit record form named "Inventory IN" which will be used to check inventory in and maintain a log for all the items scanned in.
For example:
Use Enters part#...Dlookup finds Description....... user enters quantity received
b13-211 ....................Wheel 10x15...................... 2
c12-245.................... Seat Tractor .......................15
N45-225....................Pogo Stick Red .....................3
The idea is to enter an inventory part number in the "Part Number In" field, then have code to look up and display the "Part Description" automatically in an uncontrolled "Textbox13"
The table to store the data is in the "Inventory In" Table which contains:
ID an auto number field
Time Stamp an auto date time field
In Part Number a short text field since the part numbers are alpha numeric
In Quantity a number field
Note: I am not storing the Part Description field i just need it to display on the form
The part descriptions are found in a Table Called "Part Description"
this table has the fields:
Id an auto id field
Part Number a short text field since they are alpha numeric
Descriptions a short text field
I've tried all sorts of dlookup options but I cant see to get it right
I know it should be something like
What do I want to find?
Description
What Table has the info i need?
Part Descriptions
how do we find the match
IN Part Number on current form = Part number on Descriptions Table
So i may be way off but i think it should be something like
DLookup("Description", "[Part Descriptions]="& "IN Part Number","Part Number")
Code would be ok too but i'm not very good at writing code
Thanks