Find the Record

[Syed Haider Ali]

Hi Dears,

In FoxPro to find the record we use just like the following commands. (and if found the record then rest of the fields shown in Textboxes of the userForm)

Locate for xyz=mxyz

if .not. found()

wait wind "Record does not exist"

else

Field1=textbox1
Field2= Textbox2


I need the codes for Excel vba, To find the record and if found then show the fields of the table in Textboxes of UserForm


Thanks in advance

[fazo]

Syed Haider Ali wrote:
> Hi Dears,
>
> In FoxPro to find the record we use just like the following commands.
> (and if found the record then rest of the fields shown in Textboxes of
> the userForm)
>
> Locate for xyz=mxyz
>
> if .not. found()
>
> wait wind "Record does not exist"
>
> else
>
> Field1=textbox1
> Field2= Textbox2
>
>
> I need the codes for Excel vba, To find the record and if found then
> show the fields of the table in Textboxes of UserForm
>
>
> Thanks in advance
>
>
> --
> Syed Haider Ali
> ------------------------------------------------------------------------
> Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
> View this thread: http://www.excelforum.com/showthread...hreadid=397584

[STEVE BELL]

Here's some old code from Tom Olgivy

Dim rng as Range
set rng = Cell.find( Targetvalue)
if not rng is nothing then
' found
' do something
else
' not found
End if


see if this gets you going...

--
steveB

Remove "AYN" from email to respond
"Syed Haider Ali"
<[email protected]> wrote in
message news:[email protected]...
>
> Hi Dears,
>
> In FoxPro to find the record we use just like the following commands.
> (and if found the record then rest of the fields shown in Textboxes of
> the userForm)
>
> Locate for xyz=mxyz
>
> if .not. found()
>
> wait wind "Record does not exist"
>
> else
>
> Field1=textbox1
> Field2= Textbox2
>
>
> I need the codes for Excel vba, To find the record and if found then
> show the fields of the table in Textboxes of UserForm
>
>
> Thanks in advance
>
>
> --
> Syed Haider Ali
> ------------------------------------------------------------------------
> Syed Haider Ali's Profile:
> http://www.excelforum.com/member.php...o&userid=21994
> View this thread: http://www.excelforum.com/showthread...hreadid=397584
>