Data Retrieval From A Linked Table 1

[missymarie1014]

I have a form where the record source is ReceiptTable. ReceiptTable is linked to ItemTable on the item number field. I need to be able to retrieve a value from an ItemTable field based on the item number value in the form and then run some commands based on the condition of that value. How do I go about writing code to retrieve the value in a field (Quantity On Hand) in the ItemTable based on the value in the item number control in the form which is based on the ReceiptTable and is linked to the ItemTable on the item number field? Hope this makes sense. Thanks for any help!

 

[PHV]

Bind your form to a query instead of the single ReceiptTable.
Have a look here;

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missymarie1014]

Thanks PHV. I had come to the same conclusion that I should create a query and combine the tables which would give me direct access to the fields. I also forgot that this is a subform and the parent form is based on the ItemTable so I was able to retrieve the data based on the parent form record. Thanks for responding!