Hi Hilmar.
1. I am using the same alias for different tables.
2. There is no grid in the form
3. I cannot get the memo field to open << ====== The problem.
4. I am doing exactly what you are showing in the code below.
5. Other fields and variable are working fine
Grady
---------------------------------------------------------------------
This still doesn't hinder you to use the same alias for different tables.
The RecordSource for the Grid, SELECT commands, and IN clauses, among others, all make reference to an alias, NOT to a table. The alias is very often the same as the table name, but you can assign any other alias.
For example:
* (get input from user)
* (store this input into variable lcTable)
* (and then:
use (lcTable) alias MyTable
...
select MyTable
replace ... in MyTable
Grid.RecordSource = "MyTable"
I ain't skeert of nuttin eh?
Yikes! What was that?