Creating Unbound Form for Spreadsheet interface

[KeithWilliams]

Hi,

I (think I) need to create an unbound form to implement a spreadsheet-type interface. The form needs to present a one-character value from each row of data, in a grid which will be 7 columns wide and up to about 15 rows high. The problem is the need for the number of rows to be variable. I want to read in the data using a query and populate the unbound fields.

So I tried creating a continuous form with 7 unbound controls across the top. I thought I would be able to insert rows as needed, and each row would show the 7 controls beneath the prior row. However, the Insert New Record option seems to be disabled. How can I create the 7 * 15 grid I need? Do I need to create 105 unbound controls, and hide any that I don't need? Surely that can't be right!

Please help.


Thanks,
Keith.

 

[Oldsoftboss]

You have sort of answered your own question. You say you created an Unbound continious form. The reason the Insert New Record option is that there is no record source to add the new record to. Keep in mind if you want to store the data you will need to bind the form to a table.

Dave

 

[KeithWilliams]

Hi Dave,

I understand from reading other threads that you can use an unbound form plus code to simulate a bound form, and in some circumstances this is the only way to achieve what is required. Pat Hartman referred to the case of a spreadsheet-type form in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=71385.

So I figure I am going along the right lines, I just don't know how to lay out the form to start with!

Keith.