Re: Autofill textboxes based on combobox value
First thing you should do is change the name of the "Name" field as that is a reserved word.
there are several ways to achieve what you want and a little difficult to understand with so little info.
Does your Dlookup return what you want?
if so you can use it in the after update event of the combo with something like
Me.YourTextBoxName = DLookUp("YourField","YourTable","YourCriteria")