Display Horizontal Continous Form

[calvinle]

Hi,

I have searched over the web and it seems that we cannot use continuous form to display record horizontally. For the layout of my form, I need to find a way to display them horizontally as the user need to select which product they want to open their account. For that, I found a way by creating 1 subform continuous, and insert multiple of that subform on my main form side by side. So I am going to have 3 record displayed at a time.

However, I have an issue is I only need to display 3 record per subform which I use filter in On_Load of the form.
I firstly use Filter with [id = 1] Or [id = 2] Or [id = 3] for the subform 1.
Then with [id = 4] Or [id = 5] Or [id = 6] for the subform 2, etc.
But now the issue is what if I delete those record to add new one, so the PK will change and that filter will no longer be valid.

Now my question is, is it possible to filter the first 3 record of the table. Then, in subform 2, filter the record 4 to 6, subform 3, filter record 7 to 9, etc.. That way, even I delete record, it will always pick the first 3, then second 3, third 3 and so on...

I am thinking of creating a field called [prod_id] and give it self a number from 1 to 15 (max product allowed) so if I delete any record, I simply need to reinput that prod id so it can be listed in the filter. And the filter will not be [id] but become [prod_id]. Before using this method, I Wonder if there is any other way to do so?

Thanks

 

[sneuberg]

Let's say you have a table with some order key named ID and let's say the table's name is tblCounting as in the attached database. In the qrySlots in the database there's the expression:

RN: DCount("*","[tblCounting]","[ID] < " & [ID])

Which given you sort of a record numbering. You can see that it goes 0, 1, 2, ...7 even thought there are gaps in the ID.

Not consider the expression:

Slot: [RN] Mod 3

This goes 0,1,2,0,1,2,0 ...

Maybe you can use a expression like this to filter on.


Of course the expression could be combine, e.g.

SubSlot: (DCount("*","[tblCounting]","[ID] < " & [ID])) Mod 3