Select a Row from a continous form

[Nothing]

I have a search results form that is being displayed as a continous
form.

I want to double click the name and then using VBA select the different
columns of information.

For Example:
Name City DL# Last Bid#
Michael Toledo Unknown 139
Robert Cleveland 123456 254

I want to double click the line with Michael and then assign variables I
have definned to the different columns, City, DL, Last Bid # for only
tyhe row with Michael.

I am not sure how I would do this.

Can any one help me?

Michael Charney

m b charney at sbc global dot net

*** Sent via Developersdex http://www.developersdex.com ***

[salad]

Re: Select a Row from a continous form

Nothing wrote:

I have a search results form that is being displayed as a continous
form.
>
I want to double click the name and then using VBA select the different
columns of information.
>
For Example:
Name City DL# Last Bid#
Michael Toledo Unknown 139
Robert Cleveland 123456 254
>
I want to double click the line with Michael and then assign variables I
have definned to the different columns, City, DL, Last Bid # for only
tyhe row with Michael.
>
I am not sure how I would do this.
>
Can any one help me?
>
Michael Charney
>
m b charney at sbc global dot net
>
*** Sent via Developersdex http://www.developersdex.com ***

Open up the property sheet for the field Name. Click on Events. Click
on OnDoubleClick to start coding the assignments. Ex:
Private Sub CustName_DblCli ck(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesN o,"Confirm) = _
vbYes Then
Me.BidNo = 456
Me.DL = "1234567"
Me.City = "Cleveland"
Endif
End Sub

BTW, I'm guessing at your field names

[SBC News Groups]

Re: Select a Row from a continous form


"salad" <oil@vinegar.co mwrote in message
news:yOr6h.6280 $0r.5839@newsre ad1.news.pas.ea rthlink.net...

Nothing wrote:

>I have a search results form that is being displayed as a continous
>form.
>>
>I want to double click the name and then using VBA select the different
>columns of information.
>>
>For Example:
>Name City DL# Last Bid#
>Michael Toledo Unknown 139
>Robert Cleveland 123456 254
>>
>I want to double click the line with Michael and then assign variables I
>have definned to the different columns, City, DL, Last Bid # for only
>tyhe row with Michael.
>>
>I am not sure how I would do this.
>>
>Can any one help me?
>>
>Michael Charney
>>
>m b charney at sbc global dot net
>>
>*** Sent via Developersdex http://www.developersdex.com ***

>
Open up the property sheet for the field Name. Click on Events. Click on
OnDoubleClick to start coding the assignments. Ex:
Private Sub CustName_DblCli ck(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesN o,"Confirm) = _
vbYes Then
Me.BidNo = 456
Me.DL = "1234567"
Me.City = "Cleveland"
Endif
End Sub
>
BTW, I'm guessing at your field names
>
>

I am sorry! After reading my post back "after" I submitted it I realized
that it was not correct. What I want to do is double click the line with
Michael but have the data from that line, the current City, DL#, etc.,
assign to different varriables so that I can use them else where.

Thanks,
Mike

[tina]

Re: Select a Row from a continous form

when you move to a particular record in a continuous form (which will happen
if you single click or double click in a control, or otherwise move to a
record), or in a datasheet, that record becomes the "current" record in the
form. simply assign the values to the variables; those values will always
come from the current record in the form, as

strCity = Me!City
strDL = Me!DL

it's really just that simple.

hth


"SBC News Groups" <me@you.netwrot e in message
news:Srv6h.7301 $6t.7253@newssv r11.news.prodig y.com...

>
"salad" <oil@vinegar.co mwrote in message
news:yOr6h.6280 $0r.5839@newsre ad1.news.pas.ea rthlink.net...

Nothing wrote:

I have a search results form that is being displayed as a continous
form.
>
I want to double click the name and then using VBA select the different
columns of information.
>
For Example:
Name City DL# Last Bid#
Michael Toledo Unknown 139
Robert Cleveland 123456 254
>
I want to double click the line with Michael and then assign variables

I

have definned to the different columns, City, DL, Last Bid # for only
tyhe row with Michael.
>
I am not sure how I would do this.
>
Can any one help me?
>
Michael Charney
>
m b charney at sbc global dot net
>
*** Sent via Developersdex http://www.developersdex.com ***

Open up the property sheet for the field Name. Click on Events. Click

on

OnDoubleClick to start coding the assignments. Ex:
Private Sub CustName_DblCli ck(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesN o,"Confirm) = _
vbYes Then
Me.BidNo = 456
Me.DL = "1234567"
Me.City = "Cleveland"
Endif
End Sub

BTW, I'm guessing at your field names

>
I am sorry! After reading my post back "after" I submitted it I realized
that it was not correct. What I want to do is double click the line with
Michael but have the data from that line, the current City, DL#, etc.,
assign to different varriables so that I can use them else where.
>
Thanks,
Mike
>
>

[SBC News Groups]

Re: Select a Row from a continous form

Thanks Tina,

That works great!!

Mike

"tina" <nospam@address .comwrote in message
news:19w6h.5992 9$Fi1.40857@bgt nsc05-news.ops.worldn et.att.net...

when you move to a particular record in a continuous form (which will
happen
if you single click or double click in a control, or otherwise move to a
record), or in a datasheet, that record becomes the "current" record in
the
form. simply assign the values to the variables; those values will always
come from the current record in the form, as
>
strCity = Me!City
strDL = Me!DL
>
it's really just that simple.
>
hth
>
>
"SBC News Groups" <me@you.netwrot e in message
news:Srv6h.7301 $6t.7253@newssv r11.news.prodig y.com...

>>
>"salad" <oil@vinegar.co mwrote in message
>news:yOr6h.628 0$0r.5839@newsr ead1.news.pas.e arthlink.net...

Nothing wrote:
>I have a search results form that is being displayed as a continous
>form.
>>
>I want to double click the name and then using VBA select the
>different
>columns of information.
>>
>For Example:
>Name City DL# Last Bid#
>Michael Toledo Unknown 139
>Robert Cleveland 123456 254
>>
>I want to double click the line with Michael and then assign variables

I

>have definned to the different columns, City, DL, Last Bid # for only
>tyhe row with Michael.
>>
>I am not sure how I would do this.
>>
>Can any one help me?
>>
>Michael Charney
>>
>m b charney at sbc global dot net
>>
>*** Sent via Developersdex http://www.developersdex.com ***
>
Open up the property sheet for the field Name. Click on Events. Click

on

OnDoubleClick to start coding the assignments. Ex:
Private Sub CustName_DblCli ck(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesN o,"Confirm) = _
vbYes Then
Me.BidNo = 456
Me.DL = "1234567"
Me.City = "Cleveland"
Endif
End Sub
>
BTW, I'm guessing at your field names
>
>

>>
>I am sorry! After reading my post back "after" I submitted it I realized
>that it was not correct. What I want to do is double click the line with
>Michael but have the data from that line, the current City, DL#, etc.,
>assign to different varriables so that I can use them else where.
>>
>Thanks,
>Mike
>>
>>

>
>

[tina]

Re: Select a Row from a continous form

you're welcome :)


"SBC News Groups" <me@you.netwrot e in message
news:bHw6h.2547 4$TV3.4999@news svr21.news.prod igy.com...

Thanks Tina,
>
That works great!!
>
Mike
>
"tina" <nospam@address .comwrote in message
news:19w6h.5992 9$Fi1.40857@bgt nsc05-news.ops.worldn et.att.net...

when you move to a particular record in a continuous form (which will
happen
if you single click or double click in a control, or otherwise move to a
record), or in a datasheet, that record becomes the "current" record in
the
form. simply assign the values to the variables; those values will

always

come from the current record in the form, as

strCity = Me!City
strDL = Me!DL

it's really just that simple.

hth


"SBC News Groups" <me@you.netwrot e in message
news:Srv6h.7301 $6t.7253@newssv r11.news.prodig y.com...

>
"salad" <oil@vinegar.co mwrote in message
news:yOr6h.6280 $0r.5839@newsre ad1.news.pas.ea rthlink.net...
Nothing wrote:
I have a search results form that is being displayed as a continous
form.
>
I want to double click the name and then using VBA select the
different
columns of information.
>
For Example:
Name City DL# Last Bid#
Michael Toledo Unknown 139
Robert Cleveland 123456 254
>
I want to double click the line with Michael and then assign

variables

I

have definned to the different columns, City, DL, Last Bid # for

only

tyhe row with Michael.
>
I am not sure how I would do this.
>
Can any one help me?
>
Michael Charney
>
m b charney at sbc global dot net
>
*** Sent via Developersdex http://www.developersdex.com ***

Open up the property sheet for the field Name. Click on Events.

Click

on

OnDoubleClick to start coding the assignments. Ex:
Private Sub CustName_DblCli ck(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesN o,"Confirm) = _
vbYes Then
Me.BidNo = 456
Me.DL = "1234567"
Me.City = "Cleveland"
Endif
End Sub

BTW, I'm guessing at your field names


>
I am sorry! After reading my post back "after" I submitted it I

realized

that it was not correct. What I want to do is double click the line

with

Michael but have the data from that line, the current City, DL#, etc.,
assign to different varriables so that I can use them else where.
>
Thanks,
Mike
>
>

>
>