Spreadsheet-style form

[ajarrell]

I needed to create 2 subforms that look like spreadsheet: categories are rows and months are columns. I was told that I could use a crosstab query, and everything is linking well with the main form based on an ID.

However, now I discover that I cannot enter data into a form that is based on a crosstab query, so I am back to square one. Is there any other way to make this format possible?

Thank you!

 

[JHB]

If you've good experiences in VBA programming then yes, else no.

 

[stopher]

Oddly enough I just posted spreadsheet style solution here (post 7). Let me know if you need help getting it to work. Note that your "cell" data must be unique otherwise there's no way to tell how to save it back.

hth
Chris

 

[ajarrell]

I downloaded your database but no data is displayed in the fields. I assume that, once it works, I would need to modify the code with my field names, correct?

Thank you so much for your help!

 

[ajarrell]

Okay, now the data is displayed!