Subform Junction Table Combo Box PLUS Additional Info

[Sam]

SALES
Sales_ID*
Sales_Cust_ID
Sales_Num
Sales_Date
Sales_Disc
Sales_Freight
Sales_DO_Num

SALES_ITEM
SI_Sales_ID*
SI_Item_ID*
SI_Qty
SI_Price

RECEIPT
Recv_ID*
Recv_Num
Recv_Date

RECEIPT_ALLOCATION
RA_Recv_ID*
RA_Sales_ID*
RA_Amount

I want to create a form to enter Receipts (based on table Receipt) and
subform to enter Receipt_Allocation (based on table
Receipt_Allocation). To enter RA_Sales_ID, I have created a combo box
that dropdown the Sales_ID plus other information (Sales/Invoice
Number, Date, Invoice Amount, etc.)

The thing is: I also want the subform to display this information in
textboxes on the subform. How should I go about doing this?

Thank you in advance.

-Sam

 

[Sam]

Oops... I solved it. Spent hours to figure it out, and minutes after I
posted the question I found it. So simple it's embarassing. :}

The problem was: for the subform originally I created a query JOINING
table Receipt_Allo and query Customer_Sales_Extended (have the extended
info of sales) at Sales_ID.

A regular Select query should do it.

-Sam

 

[Sam]

Use DLookup. But it's somewhat slow even with little data. Wonder how
it'll do with real data.

-Sam