Populate a Table based on Dlookup values in a Form

[dmeyr]

Hello,
I am new to Access and am having difficulty with a Dlookup function. I have a form that I wish to autopopulate 10 fields with values based on two criteria which are also fields on the form. The user would enter the two criteria in the form and the ten fields autopopulate. To achieve this, I used a Dlookup function in the Control Source of the fields I wished to autopopulate.

These Dlookups work perfectly except that my table does not populate with the values retrieved in the Dlookups. The information that I am retrieving thorugh the Dlookups is unique data that I need to add into my existing table, not duplicative in nature.

Is there another way to execute the Dlookup so that the table will be updated, or is there a different method that should be used to achieve this?

Any direction on this would be greatly appreciated!! - Thanks!

[MMcCarthy]

Are the 10 fields all in one table or based on a query. I don't know if the DLookup was the right function as I'm don't know the logic behind them.
Is your form bound to a table or query and are the 10 fields bound to the corresponding fields.

You will need to provide a lot more information starting with the above. Also check out the post at the top of the Access forum with POSTING GUIDELINES. This should help you to determine what you need to include.

Also try to give a concise explanation of the logic behind what you are trying to do. The more information you provide the better we'll be able to help you.

Hello,
I am new to Access and am having difficulty with a Dlookup function. I have a form that I wish to autopopulate 10 fields with values based on two criteria which are also fields on the form. The user would enter the two criteria in the form and the ten fields autopopulate. To achieve this, I used a Dlookup function in the Control Source of the fields I wished to autopopulate.

These Dlookups work perfectly except that my table does not populate with the values retrieved in the Dlookups. The information that I am retrieving thorugh the Dlookups is unique data that I need to add into my existing table, not duplicative in nature.

Is there another way to execute the Dlookup so that the table will be updated, or is there a different method that should be used to achieve this?

Any direction on this would be greatly appreciated!! - Thanks!