Lookup can be used as many times as you need but if you are using it for several fields from the same table on the same forms.

It typically only brings the field you specify inthe first parameter. For example,

X / dlookup("Address","TableT", "RecordID=" & ID(

Should only bring the address from table named "TableT" where the id field natches.

Interesting. I am using it for address,city,state,zip, and telephone # getting the data from my vendor table. I am using it on several forms. And I only use =DLookUp("VenAddress","VendorT","VendorID=" & [VendorCombo]) in the address field and it brings over all of the fields at once. I do not have have to use it in each field. It works. Thank you

Screenshots of your design might be helpful. Are you storing all that information in a single field in the table?

No its separate fields. Which screen shot do you want to see?

Your table looks fine for a vendor table to record the information. The pics don't clearly identify the form structure. What is the record source for it? Do you have any code for the combo box (like auto fill the address and phone fields)?

Ok Ben Here is what I hope you are looking for. And there is no code for auto fill. The Dlookup auto fills soon as I put the vendor name in the vendor field.

I just reread my earlier questions and realized I may not have been as clear as I intended. Is that last pic your control source for the form or for the combo box? If it is for the form, I would be very confident that is why the address fields are getting filled in as soon as you select a vendor.

It is for the form. I think I didn't snip it correctly. Here is the Info I think you wanted.

I would say that's your complication. Having that sql statement as the form record source is likely pulling in the additional information. Unfortunately, im not fluent enough in SQL to say for certain. Based on my experience and what seems to be Richard's teaching, the proper reliable way is to set your form record source to a table like MagazineT possibly MagazineQ which would contain MagazineT.* plus your calculated total cost with a subform tied to VendorT.

I have a query for my calculated TotalCost. I think I brought the query in and used all the fields in the query. That SQL listed above is what access did on its on. I am not savvy at SQL at all. If that will cause problems for me then I shall change things. Thank you. I just changed it and the DLookUp is doing what it is suppose to do I believe. Thank you