If I have a form invoicing details sub form viewed in a datasheet view in which I want it to look up info from the order details form and save it in the invoicing details tbl would I be able to use the Dlookup function? Also if there are more than one items in the invoicing detail sub form would I be able to see the multiple items?
