Updating data trough form in crosstab mode

[chrisjones99]

Dear,

I've got a table with :

Country;Customer;Product;Date;Data

I've tried to make a form in order to update data(revenue) for a customer that has several products for several dates(months).

i want a display with the months in column, but that's trough a crosstab, so it isn't the solution because Access says i cannot update record like this

Is there a way to make a form linked to this table and to see several records with the date(months) in column format in one form.

ex:

customer Date 1 Date 2 Date 3

product 1
product 2
product 3
etc..

Thank you in advance for the time and energy you put to read me.

Best regards

Chrisjones