Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement
Message
 
To
20/06/2002 16:17:24
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00670488
Message ID:
00671001
Views:
17
In the button that calls the second fomr put this;
mfindrefnumber = 0
DO FORM Whatever && Call the second form
* Now do your stuff based on what the user selected
if mfindrefnumber <> 0

	SELECT * from refdocswithaddress INTO CURSOR SpecificDoc nofilter;
		WHERE refdocswithaddress.number = mfindrefnumber
	
	mDocNum = SpecificDoc.Number
	mLastname = SpecificDoc.Last_name
	mFirstname = SpecificDoc.First_name
	mStatus = SpecificDoc.status
	mSpeciality = SpecificDoc.Speciality
	mAddress1 = SpecificDoc.ClinicAdd1
	mAddress2 = SpecificDoc.ClinicAdd2
	mLocation = SpecificDoc.Location
	mPostalCode = SpecificDoc.PostalCode
	mPhone = SpecificDoc.Phone
	mCell = SpecificDoc.CellNumber
	thisform.refresh()
endif
You don't need to change anything in the called form.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform