Rearrange subform

[diverman]

I have a form with two subforms.
The left hand subform shows 10 records.
The right hand subform shows 10 records.
Each subform is populated from its own table/query.

I want to be able to tick boxes in the left and right subforms and have the right hand subform shuffle so that the records match.

I thank you all for any help.

Gordon

[NeoPa]

A clearer explanation of the problem would help people to understand.

[diverman]

Thanks for reply NEO.

My form has subform1 and subform2.

Subform1 is on the left.
Subform2 on the right,

Both subforms are set for continuous forms.

I want to have a tick box or similar in the records showing.

So I "tick" a record in subform1 and "tick" a record in subform2.

Then on a command button click, I want subform2 (on the right) to be sorted or arranged so that the records in both line up alongside each other.
---------------------------------------------------------------------------------------------------------------
I don't know how to explain better but here goes!

10 records on the left.
10 records on the right.

Tick a box in first record on the left,

Look down right hand records and tick the tick box in the record of choice.

After making a selection, press a command button.

Now the records on the right are rearranged so that the record on left and record on right are lined up.

I then tick a box in second record on left.

Look down right hand records and tick the tick box in the record of choice.

After making a selection, press a command button.

Now the records on the right are rearranged so that the record on left and record on right are lined up.

I do this for all records on show.

[NeoPa]

Sorry, but I don't think there's any way of doing this.

I was interested in knowing if the data on the left and the data on the right had any info or fields in common. You can re-sort datasets and you can restrict the contents of datasets. Both of these techniques can be used to match up data.
Unfortunately, you seem to need reorganising of the data in a random (unspecified) order, with the only requisite being that an individual record must come in the specified ordinal position (it must come nth in the list).

[NeoPa]

You might be able to do something similar, though, if you had an updatable field in each of the recordsets that you could assign a number to.
That way, the datasets could be sorted by those numbers and the left should match the right (only after you've assigned the required numbers though).
It's a bit kludgy, I know, but the only thing I could come up with.

[diverman]

If I have records A,B C,D,E,F down the left and A,B,C,D,E,F down the right.

I look at the left, first record is A, look down right, choose C, press command button.

Hey presto! :-)

Record A, on the left now has Record C on the right in line.

I look at the left, next record is B, look down right, choose F, press command button.

Hey presto! :-)

I now have:-

Record A Record C
Record B Record F

I make all the selections until I get to the 10th record (the last on show)

That is what I am trying to do.

I thought of putting a number or letter into a field on both sets of records and try to select on that.

I don't want to sort using ascending from the tool bar

Any Ideas welcome

[PEB]

But this is possible..

Yeah...

Just sort by the box that you've thicked.... And other column..

So when your boxes are all unticked so the sort will be on the other column

And when there is a thick you will need only to refresh or requery your subforms..

with the method refresh or requery

I don't see why don't you use the sort on your subforms...???

:)

[diverman]

But this is possible..

Yeah...

Just sort by the box that you've thicked.... And other column..

So when your boxes are all unticked so the sort will be on the other column

And when there is a thick you will need only to refresh or requery your subforms..

with the method refresh or requery

I don't see why don't you use the sort on your subforms...???

:)

--------------------------------------------------------------------------

Thanks PEB, I shall give it a try.

Gordon.(a beginner)

[Happy YN]

Each time you tick a box you could add code that would append some unique identifer to the string in the field - precede by a special character e.g A@1 then add the same to the other field C@1 . Of course the form would strip off these appended bits so the user wouldn't see them using a string function such as Left([Field1],(InStr([Field1],"@"))-1). You could then order by these appended numbers - obtained again by stripping off the 'left' bit i.e Right([Field1],Len([Field1])-(InStr([Field1],"@"))).
For the next line the code would loop to add a @2 to the strings etc
Let me know if this helps or if you solved it a different way.
Thanks

[NeoPa]

I'm sorry but I had to edit your post to remove the link you posted as it is in violation of the rules posted at the right of the page when entering a post :-

Do not link to other websites for promoting/traffic generation. Only link to helpful resources.

[Happy YN]

Sorry I had not noticed that as I am new to this forum. I will however post my problem as a seperate thread

[NeoPa]

That's not a problem.
A separate thread sounds like a good idea and hopefully we can find a solution or two that you haven't come across before :)