Dlookup or otherwise, grabbing data

[OutbackInvestments]

Hi again.

I am currently trying to grab information from a foriegn table and have it displayed as the default value (I dont want to have then related so that if I change 1, it does the other) and I am attempting to use the Dlookup command. The value I want to look up is StockPrice from the StockTable and place it in the ReceiptTable. ReciptID and StockID are in a 1 to many relationship (1 stock has many receipts (purchases)) How do I get the price into the receipt form? Please help.

Thanks.
R bissonnette.

 

[AlaskanDad]

The DLookup function gives you a value. You can do things with that value once it is calculated. To use your variables, the code would be
=DLookup ("[StockPrice]","StockTable", "[StockID] = howeveryoupickthestockID"