MS Access Text Box

Viewed 30

Access for Microsoft 365. Form design-->Text box.

I have created a text box but when I save the same text it is displayed in all the individual records. How do I get a different text for each individual record? For example: I have 50 different customer records. I have a label titled fruit fo all 50 records. If I write in the text box 'apple' in the first record label all 50 records will have the same text box 'apple' How do I achieve to have different fruits for each records?

1 Answers

Add that "fruit" field to the table, then bind your textbox to this field - like the other fields you display on the form.

Set the ControlSource property of the textbox to: YourNameOfTheFruitField

Related