Aliases in Update Queries

[roccogrand]

I have the following query:

UPDATE tblMyQuestions SET tblMyQuestions.StudentName =
tblStudentCodes.StudentCode;

When it is run, it says "Enter Parameter Value" and then displays
"tblMyQuestions.StudentName"

I would like to change the first phrase to "Enter your student code" and not
show the table.field value at all. Is this possible?

Thanks.

LDN

 

[Michel Walsh]

Your table myQuestions have a field StudentName ?

if so, something like:


UPDATE myQuestions
SET StudentName = [Enter your student code]


or, maybe


UPDATE myQuestions
SET StudentName= DLookup( "StudentName", "StudentCodes", "StudentCode=" &
[Enter your student code] )



Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Forgot to mention that without any WHERE clause, your UPDATE will update ALL
records with the single value you supplied! Probably not what you really
want.



Vanderghast, Access MVP

 

[roccogrand]

Thanks Michel,

This looks like it may work. I will try as soon as I get home tonight.

I do want the field to be completely updated, i.e., flushed of very student
code. I use another table to archive the data at runtime if the user needs
to store his/her data, otherwise the field is overwritten.

Thanks again.

LDN