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 *** | | | | re: Select a Row from a continous form
Nothing wrote: Quote:
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 | | | | re: Select a Row from a continous form
"salad" <oil@vinegar.comwrote in message
news:yOr6h.6280$0r.5839@newsread1.news.pas.earthli nk.net... Quote:
Nothing wrote: Quote:
>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 | | | | 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.netwrote in message
news:Srv6h.7301$6t.7253@newssvr11.news.prodigy.com ... Quote:
>
"salad" <oil@vinegar.comwrote in message
news:yOr6h.6280$0r.5839@newsread1.news.pas.earthli nk.net... Quote:
Nothing wrote: Quote:
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 Quote: Quote: Quote:
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 Quote: Quote:
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
>
>
| | | | re: Select a Row from a continous form
Thanks Tina,
That works great!!
Mike
"tina" <nospam@address.comwrote in message
news:19w6h.59929$Fi1.40857@bgtnsc05-news.ops.worldnet.att.net... Quote:
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 ... Quote:
>>
>"salad" <oil@vinegar.comwrote in message
>news:yOr6h.6280$0r.5839@newsread1.news.pas.earthl ink.net... Quote:
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 Quote: Quote:
>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 Quote: Quote:
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
>>
>>
>
>
| | | | re: Select a Row from a continous form
you're welcome :)
"SBC News Groups" <me@you.netwrote in message
news:bHw6h.25474$TV3.4999@newssvr21.news.prodigy.c om... Quote:
Thanks Tina,
>
That works great!!
>
Mike
>
"tina" <nospam@address.comwrote in message
news:19w6h.59929$Fi1.40857@bgtnsc05-news.ops.worldnet.att.net... Quote:
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 Quote: Quote:
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 ... Quote:
>
"salad" <oil@vinegar.comwrote in message
news:yOr6h.6280$0r.5839@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 Quote: Quote:
I Quote:
have definned to the different columns, City, DL, Last Bid # for
only Quote: Quote: Quote:
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 Quote: Quote:
on Quote:
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 Quote: Quote: Quote:
that it was not correct. What I want to do is double click the line
with Quote: Quote: Quote:
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
>
>
>
>
|  |
Similar Microsoft Access / VBA bytes | | |  Forums
Visit our community forums for general discussions and latest on Bytes
/bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,576 network members.
|
