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]

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_DblClick(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesNo,"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]

"salad" <oi*@vinegar.comwrote in message
news:yO****************@newsread1.news.pas.earthli nk.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_DblClick(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesNo,"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]

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" <[e-mail] in message
news:Sr****************@newssvr11.news.prodigy.com ...

>
"salad" <oi*@vinegar.comwrote in message
news:yO****************@newsread1.news.pas.earthli nk.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_DblClick(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesNo,"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]

Thanks Tina,

That works great!!

Mike

"tina" <no****@address.comwrote in message
news:19*******************@bgtnsc05-news.ops.worldnet.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" <[e-mail] in message
news:Sr****************@newssvr11.news.prodigy.com ...

>>
"salad" <oi*@vinegar.comwrote in message
news:yO****************@newsread1.news.pas.earthl ink.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_DblClick(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesNo,"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]

you're welcome :)
"SBC News Groups" <[e-mail] in message
news:bH******************@newssvr21.news.prodigy.c om...

Thanks Tina,

That works great!!

Mike

"tina" <no****@address.comwrote in message
news:19*******************@bgtnsc05-news.ops.worldnet.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" <[e-mail] in message
news:Sr****************@newssvr11.news.prodigy.com ...

>
"salad" <oi*@vinegar.comwrote in message
news:yO****************@newsread1.news.pas.earthli nk.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_DblClick(Cancel As Integer)
If msgbox("Confirm Update for " & custname,vbYesNo,"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