Autofill from cascading comboboxes

[Dougalsworld]

Hello Again

I've searched the forum but can't quite find what I'm looking for.
I have one main table (tblFOBData) with the fields Material, MarketCode, Vendor and Cost.
I also have a form that uses the Material and MarketCode fields in cascading combo boxes and this works fine,
However,
If you select a Material and MarketCode it will only return a single record and so I would like to autofill the data from the other two fields on to the form, preferebly without using a subform is this possible

Thanks again

 

[MStef]

Try to use DLOOKUP function for this.