Serch Form

[shahid]

I am using vfp6 I want to create form
I am using customer information table. I want to enter the phone number. form should display all the information about the customer from all the field. If customer phone number is found.
If there is no phone number match. Form should go to automatic edit mode and accepts the information like data enter form. Please help

 

[danceman]

if you have an index on the phone number.


IF !seek('customer','phonenumber')
append blank
ENDIF

thisform.refresh()

more information is needed.
are you doing a search form first to ask for the phone number then run the form to show only that record??
in search form, after getting number
IF seek('customer','phonenumber')
do form frmcust with recno()
else
wait window 'phone number not found' nowait
endif
in the init of the frmcust
prameter nrecno
use this to goto record
or select statement to retirve record.

is the form showing the customer data open first showing customer data, then a search is to be done when clicking a button to fine by pnonenumber??

Attitude is Everything