Valid field names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

PLease hel
I continue getting this messag
"The microsoft jet database engine does not recognize 'Rent.Quickname' as a valid field name or expression
"Rent" is the for
"Quickname" is the field
What can I do to fix this problem?
 
Although you don't say it which context this message
appears, try using Forms!Rent!Quickname

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
PLease help
I continue getting this message
"The microsoft jet database engine does not recognize
Click to expand...
'Rent.Quickname' as a valid field name or expression"
 
Cogger said:
PLease help
I continue getting this message
"The microsoft jet database engine does not recognize 'Rent.Quickname' as a valid field name or expression"
"Rent" is the form
"Quickname" is the field
What can I do to fix this problem?
Click to expand...
You can say this, if it is a control on a form.
Forms!Rent!Quickname or Me!Quickname

If this is a field in a table, you can use DAO.
Dim dbs As Database
Dim rs as RecordSet
Set dbs = CurrentDb
Set rs=dbs.OpenRecordset("TableName")
rs!Quickname

If you are new to Access, it will help you greatly if you learn and use
the correct names for objects.
This will make it easier for others to answer your questions.

You said "Quickname" is the field

Quickname is a control on a form that is bound to a field in a table.
The property ControlSource is used to define which field in the table
that is bound to the control named Quickname.

Ron
 
sorry I forgot to mention tha
I am trying to connect a button on one form to open specific data on another.
 
Back
Top