Problem with DLookup on Form

[jboeder]

I am trying to get a text box on a form to auto-populate a dollar value based on the selection within the combo box on the form. I keep getting either #Name? or #Error no matter how I structure the control source code.



=DLookup("Base Pay", "GSPayT", "GSLevelandStepF=" & GSLevelandStepCombo)

This was my first try but it kept throwing #Name? and I am not sure why. I thought that maybe the problem was that the GSLevelandStepF field was in a different table from the other data so I tried the next code.

=DLookUp("Base Pay","GSPayT","[EmployeesT]![GSLevelandStepF]=" & [GSLevelandStepCombo])

It then was only throwing #Error. Probably because I used quotes with brackets, but I don't know how to structure this differently.

Lastly, I am hoping that the populated value can be added to the EmployeeT table when the form is submitted but I am not sure how to do that either.

[pbaldy]

GSLevelandStepF has to be a field in GSPayT; is it? I'd try to include the field in the combo's row source and do this:

https://www.baldyweb.com/Autofill.htm

[Welshgasman]

Do not have objects with spaces in the names. Then you have to surround them with [ and ].

You used them pretty much everywhere except where needed for Base Pay, which I would have called BasePay.

[June7]

Domain aggregate functions can cause slow performance in queries and on form. Use combobox approach described by pbaldy.