Select a Row from a continous form

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 ***

Nothing wrote: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

"salad" <oil@vinegar.comwrote in message
news:yOr6h.6280$0r.5839@newsread1.news.pas.earthli nk.net...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

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.netwrote in message
news:Srv6h.7301$6t.7253@newssvr11.news.prodigy.com ...Ion

Thanks Tina,

That works great!!

Mike

"tina" <nospam@address.comwrote in message
news:19w6h.59929$Fi1.40857@bgtnsc05-news.ops.worldnet.att.net...

you're welcome :)


"SBC News Groups" <me@you.netwrote in message
news:bHw6h.25474$TV3.4999@newssvr21.news.prodigy.c om...alwaysvariablesonlyClickrealizedwith