diplay value from datasheet view in unbound textbox

[megatronixs]

Hi all,

I have main form where I have a subform in datasheet view. The datasheet is on top and below in the main form I have a set of unbound text boxes that I use to create an email. What I need now is to use the datasheet that displays events created earlier to pass them to the the unbound text boxes based on the selected event_id.
If I would click on event_id 1, it will populate all the unbound textboxes from that record on the main form.

Any ideas how to do this?

the main form is called: frm_main
the subfrom in datasheet view is called: frm_internal_training_subform
some of the fields I try to puplate:
event_id_text
training_name_text
training_topic_text
etc.

Greetings.

 

[megatronixs]

Hi all,

I added a example database to make things easier.

Greetings.

 

[bob fitz]

I think there might be a better way to go about this.
Why not have a form bound to the event table and then have a combo box on that form to find the required record. You can even get the wizard to create the combo box for you.

 

[megatronixs]

hi,

I actually discovered that it will not be a easy task. The subform in datasheet view is based on the table tbl_create_event. I added another subform based on the same table to the main form as this one has some fields in it, but from different table. I can't link 2 sub forms on eachother, even based on the same tabl.

Greetings

 

[bob fitz]

Have you created the combo box as I suggested?

 

[megatronixs]

Hi,

I fixed it by using a form that pops up when doulble click one of the Event ID in the datasheet view. The form that opens shows all the data from the current selected record.
The unbound text fields that are now in the main form, I use them to create a new event.

Greetings.