Access - Get subForm datasheet value of row

[Oflores23]

I have a subform which is created with textbox and some command button in the top of the window, so this will simulate like a Datagrid.

http://imgur.com/MpIpksT

This is how it looks my datagrid when it fills from a Query.

http://imgur.com/kxAS8Ff

What I want is when I select a row from my subform, I want to Click the button "Cambiar", and get the value of the machine selected.

http://imgur.com/LCEQlSI

[twinnyfo]

When posting images, please use the Advanced button, as many of us can't view image server sites at work.

What do you mean that you want to "get the value of the machine selected"? What do you want to do with that value?

You may be able to make a direct reference:

Me.zfrmStatus.Machine_Name

but that may likely refer to the first record in the subform, since your focus has moved to the Main Form.

Depending on what the "Cambiar" button does, you may want to switch the subform to a Continuous Form (instead of datasheet). This allows you numerous advantages.

First, you can resize and arrange columns more easily. Second, you can add a button in the detail section of the subform (Cambiar) and when you click on the button associated with that record, you can refer directly to that particular record:

Me.Machine_Name

Again, it depends on how you want to use that value.

[Oflores23]

@twinnyfo
Isn't a Continous Form that Form? sorry i'm just newb at this, they are only 1 text box so it appears at many rows depends on my query.

OK, I just tried to get the single value of a column depending on the row I select, this is because I want to change the value in another form. But to express that idea its a little bit more difficult, that's what I only want to get the value, even juts to show in a Msgbox.

For example if select row 2, I want to get the value of the machine_name "ATO 02", but that in case I had filted "Operacion", maybe I filter in other thing, and now row 2 its "MINI 02" so how I can get the value not of the row, but the column or the textbox of that.

[Oflores23]

@Oflores23
Solution:

http //imgur.com/gikNKPc

I just write:

Referred from:
http //access.mvps.org/access/forms/frm0031.htm

MsgBox Me!zfrmStatus.Form!txt_machine_name.Value

and it brings the value from the selected row.

Thanks for the HelP!