Valid field names

[Cogger]

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?

 

[Gerald Stanley]

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

'Rent.Quickname' as a valid field name or expression"

 

[Ronald W. Roberts]

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?

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

 

[Cogge3]

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