Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Will Berg
  Where is Will Berg?
 
 Netherlands
 Will Berg
 Tags
Subject: RE: Macro substitution
Thread ID: 33778 Message ID: 33787 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Wednesday, December 03, 2003 5:07:18 PM         
   


Depending on the details in your apllcation you may try this:

In the textBox.Init or textBox.Refresh add:
this.ControlSource=gcFile+"."+firstname


>
> Hi there,
>
> I need to refer to a table without knowing its name at that time. I tried the following in the ControlSource of a Textbox using macro substitution
> but it didn't work:
>
> gcFile : the alias of the table
> firstname: the fieldname in the table and the source for this textbox
>
> &gcFile..firstname
>
> The same problem exists in the ControlSource of a grid, where I want to show different names from the same table.
> When entering the above text an error occurs. This erro didn't show when entering the same in the ControleSource of the Textbox.
>
> Any ideas how to solve this ??
>
> Thanks in advance
>
>
> Will
>
>


ENTIRE THREAD

Macro substitution Posted by Will Berg @ 12/3/2003 2:46:51 PM
RE: Macro substitution Posted by Yuri Rubinov @ 12/3/2003 5:07:18 PM