Hello to whomever is reading this.
In my form, user inputs some basic information into fields. Name, age, height, weight.
Based upon this, several other form fields are automatically filled in with dLookUp(). Life expectancy, BMI.
When using this form to add a new record, I have no trouble assigning the control source of the form fields that the user inputs (= corresponding columns in my desired storage table). I can add those into the new record, no problem.
But I don't know how to also add to the new record the forms fields whose control source is dLookUp()?
What would be a correct way to do this?
* * *
I also noticed that when I manually delete a record added using the form, the form fields with control source bound to the table refused to cooperate - value in those fields is something like #DELETED. This is not a desired behavior for me, am I doing something wrong? I want to be able to delete old records with the form still working.
Thank you for your time!