Multi column data selection

C

Cnone

i have a subform listing data according to a combo box selection but, it
shows 5 columns of a data like (firstname,lastname,phone,email,adress) and i
use a check box to choose the record. The problem is i want to copy the
whole row data which consists of 5 columns to another box , that box should
show me the the whole row data which i choose from subform by clicking the
check box.
How can i do this?
 
G

Graham R Seach

Use the combo's Columns collection:
Me!Textbox1 = Me!Combo.Column(0)
Me!Textbox2 = Me!Combo.Column(1)
Me!Textbox3 = Me!Combo.Column(2)
Me!Textbox4 = Me!Combo.Column(3)
Me!Textbox5 = Me!Combo.Column(4)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
C

Cnone

Thanks for your attension, but i have another problem with this, how can i
copy that row to another field. I mean it should be something like "add
menu" i will mark the row with check box and after clicking on a button it
will copy the marked row to another field.
 
G

Graham R Seach

Perhaps I've misunderstood your original question.

If I understand you correctly this time, you want to mark a row in a
continuous form by ticking a checkbox in that row. You then want to be able
to click a button and copy the "selected" row's data somewhere else.

Copying a row's data is fairly easy, but marking a single row in a
continuous form is not.

I'm guessing, but I think the following link might help:
http://www.lebans.com/conformscurcontrol.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
C

Cnone

Yes, that's true you compeltly unsderstood my problem maybe i couldn't
explain breifly on first time.but when i tried your example i couldn't
figure out how to do it because, as i see it shows me record of a specific
column if i bring the cursor on that record and also shows the id of that
record.
But, i want to list many rows:
please think like this;
there is continuous form and as you mentioned i will thick a check box and
with by thicking the whole row will be selected , but there can be 3 or more
rows that will be selected. After this i thought to put a command button to
show the thicked records on another field (it can be a list box, continuous
form or a combo box, doesn't matter what kind of a field it is.) i have
tried to create a subform to show these results but it didn't work
correctly. Because, these results can be changed any time and should be
updated every time the value of the check box changes.
At first, i thought to do this with double clicking on the record but i
couldn't manage it.
So, if i could explain everything correctly now, can you tell me is it
possible or how can i do this .

Thanks for your attension,
Regards,
Sinan Ceran
 
G

Graham R Seach

There is no native way of doing this. Even if you were to put unbound
checkboxes on the continuous form, when you check on eof them, they will ALL
be checked. That's just the way Access works.

The only thing I can do is to point you in a direction which will help you
research a solution, if it is possible at all.

Check out http://www.lebans.com/conformscurcontrol.htm. Steven Lebans is our
resident wizard. If there is a way to do it, he'll know, and perhaps the
above link will get you started.

Other than that, I'm afraid you're out of luck, and you should think of
another way to do it. For example, if you don't need to edit the data shown
in the continuous form, you might consider using a listbox. Using this
approach, you can select and highlight multiple records, which will give you
the functionality you want.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
C

Cnone

Ok, you are right, maybe i should try another way.Unfortunetly i may be not
able to do what i want.
Thanks again,

--
 
G

Graham R Seach

You can still ask for help here once you decide which way you want to go.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
Top