Data mellem to lister

mr.j>You are going to need either a new table conatining those selcted OR an extra field in the existing table which is used for marking those which are selected.

when you double click on one of the names in the first list you either set the extra field to True and then refresh the form. The first list only selects those where th extra field is false and the second list only selects those where the field is true.

Hope it gives you some ideas

This is not something which Access can do automatically so you wil have to use some code for this.

Du menner man skal ind og rode i udtryksgenerator?? Den siger mig ingen ting! Har du et eksempel?? Tak for det hurtige svar!

Nå nu kom jeg til at give dig point! Håber du vil hjælpe!

If you have a database you can send it to eksperten@santhell.dk and I will put something together for you.

please ZIP the dB if you send it :o)

Er du sikker?? Du skal ikke havde noget for det vel???

If I have understood the question correctly then it isnt going to take long so 60 points is what you pay :o)

Have I understood yopu rquestion correctly? Yo want to move a nem from one list to another when you double click on it?

yopu rquestion  = your question

Okay har sendt filen!
Tak

MVh Jack Nielsen

Ja det er det jeg vil! Skal så bruge indholdet i den liste til at putte ind i en kombinationsboks i en anden formular! så man kan vælge dem!

Jack, if you want to put them in a combo on another form then wouldnt it be best if you had a check box field on the first form then those which are selected (checked) get shown in the next form (combo)? This way you dont need to show then in another list!

Jo det ville det jo enlig! Men der skal vel stadig bruges kode!
Men det lyder noget smartere!

Har du fået filen??

Yes I have received the file.
I may have been too quick there about using a checkbox, I dont think its possible to display a checkbox in a list. I'll do it as you wanted first so you can see how it works.

Ok! Det lyder godt!

I have sent the dB backto you, hope it can be of use.

This is for other users.
New field added to table named Selected when a record is double clicked I updated the field to either true or false. When I open the form I set them all to false to make sure they are all in the first list.

and here is the code for the form.

Option Compare Database

Private Sub Form_Load()
DoCmd.RunSQL "UPDATE test SET Selected = 0 "
Me.Refresh

End Sub


Private Sub lstKunder_DblClick(Cancel As Integer)

DoCmd.RunSQL "UPDATE test SET Selected = -1 WHERE [Leverandør ID] = " & Me.lstKunder
Me.Refresh

End Sub

Private Sub LstSelected_DblClick(Cancel As Integer)

DoCmd.RunSQL "UPDATE test SET Selected = 0 WHERE [Leverandør ID] = " & Me.LstSelected
Me.Refresh

End Sub

Mange tak for hjælpen!
Hvis jeg skulle møde dig en dag så husk mig på at jeg skylder dig en øl:-)

Mvh Jack Nielsen

:o)

Could you use what I sent?

Ja det kunne jeg!

Men det er da vildt at man skal bruge VBA for at det kan lade sig gøre!

jeg takker mange gange!

MVH Jack

Den kommer med en advarsel når man åbner formularen hvor der står: "du er ved at opdatere rækker!". Kan man fjerne den?

Mvh jack

yes
place the line BEFORE the Dcmd.RunSQL .....
docmd.setwarnings False

and this AFTER
docmd.setwarnings True

Hold da fast!!
Du er ret hård!
Det havde jeg aldrig selv fundet ud af!

Tak skal du havde!

Mvh jack

:o)