Unbound field on a form

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

Guest

I'm trying to get a number from a query or table but can't get it to work.
Any suggestions?

Thanks,
 
Need more information on what you are trying to do. I can only guess from
your header and your post that you want to get a number from a query or table
and put it in an unbound control. (fields are in tables and queries, controls
are on forms).
It isn't hard to do, but we need to know how you are addressing the table or
query, how you know which row you are on. What happens to cause the value to
be retrieved from your table/query and inserted into your control.
 
Thanks for the explanation on the control.

I have two tables called Tbl Customers and Tbl Questions. They are linked 1
customer to many questions. The form name is Frm Tbl Customer1

=[Tbl Questions Query Count]![Count Of Tbl Questions]
This is what I get in the unbound control on the form. #Name?

Thanks for your help
 
Where is this code:
=[Tbl Questions Query Count]![Count Of Tbl Questions]

The #Name you are getting means it can't find the name of the object you are
referencing. Also, you referencing a query and field name.
If the above field needs to go into an unbound control, then you need to
create a recordset to use it. then Reference it in the Current event of your
form:

Me.MyUnboundControl = MyRecordSet![Count Of Tbl Questions]

Fly Boy5 said:
Thanks for the explanation on the control.

I have two tables called Tbl Customers and Tbl Questions. They are linked 1
customer to many questions. The form name is Frm Tbl Customer1

=[Tbl Questions Query Count]![Count Of Tbl Questions]
This is what I get in the unbound control on the form. #Name?

Thanks for your help


Klatuu said:
Need more information on what you are trying to do. I can only guess from
your header and your post that you want to get a number from a query or table
and put it in an unbound control. (fields are in tables and queries, controls
are on forms).
It isn't hard to do, but we need to know how you are addressing the table or
query, how you know which row you are on. What happens to cause the value to
be retrieved from your table/query and inserted into your control.
Click to expand...
Click to expand...
 
I don't know what you mean by a record set. I'm trying to fill the unboud
control with info from a query of Tbl Questions. I still got the #Name when
I copied your formula into the unbound control.

Thanks for your help!

Klatuu said:
Where is this code:
=[Tbl Questions Query Count]![Count Of Tbl Questions]

The #Name you are getting means it can't find the name of the object you are
referencing. Also, you referencing a query and field name.
If the above field needs to go into an unbound control, then you need to
create a recordset to use it. then Reference it in the Current event of your
form:

Me.MyUnboundControl = MyRecordSet![Count Of Tbl Questions]

Fly Boy5 said:
Thanks for the explanation on the control.

I have two tables called Tbl Customers and Tbl Questions. They are linked 1
customer to many questions. The form name is Frm Tbl Customer1

=[Tbl Questions Query Count]![Count Of Tbl Questions]
This is what I get in the unbound control on the form. #Name?

Thanks for your help


Klatuu said:
Need more information on what you are trying to do. I can only guess from
your header and your post that you want to get a number from a query or table
and put it in an unbound control. (fields are in tables and queries, controls
are on forms).
It isn't hard to do, but we need to know how you are addressing the table or
query, how you know which row you are on. What happens to cause the value to
be retrieved from your table/query and inserted into your control.

:

I'm trying to get a number from a query or table but can't get it to work.
Any suggestions?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top