MS Access - How can I unlink text boxes in a form

2019-07-26 09:02发布

问题:

I have a form that relates to different products and their feedback. The intention of the form is to add new feedback to Feedback table. Present on the form are fields that are currently linked to Products table. But I do not want to add anything to the Products table, the text fields are just there for reference.

However, when entering data into this form, I am returned with an error asking me to enter data into fields. These fields are controlled with a DLookup function. But I do not want to enter data with these fields anyway - they are just for reference.

How can I unlink these text boxes from their table, so that when entering data into this form, the discussed fields are disregarded?

Edit:

screenshot of form in design view

This is what my form looks like in design view. I would like the first seven rows to be for user reference only and to have no effect on the Products table. The final five rows and fields present in the Feedback table - I would like these to be added.