Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to 'rerun' SQL statement Record Source?
Message
 
To
05/08/1998 11:31:06
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00124108
Message ID:
00124133
Views:
17
>Hi all,
>
>I've got a dropdown list whose recordsource is a SQL statement (type 3). It creates a cursor (contact names) which is used for the list. I'm allowing the users to enter another form to add a new contact.
>
>What I need to do is once they've added a new record in my table being used in the SQL statement and return to the main form, is 'rerun' the SQL statement in the recordsource to update the list.
>
>Where/how can I do this??
>
>mtia!
>
Mandy,

Call the Requery method of the list object.
Previous
Reply
Map
View

Click here to load this message in the networking platform