unbound control

  • Thread starter Thread starter oldLearner57
  • Start date Start date
O

oldLearner57

hi community

i had 2 tbl, helpDeskTBL and AuthorsTBL & both are related.
had already created a Form, helpDeskFRM based on helpDeskTBL
&
wanted to have a field name Publisher inside the helpDeskFRM so i used the
tool wizard to create an "unbound" field &
use the Expression Builder to create a bound field, =[AuthorsTBL]![Publisher]
but
when i return to the Form view, it shows #Name?

can anybody kindly guide me on this

10s!

10s community as well
 
The ControlSource for each control, if it is bound to a table, must be a
fieldname in the RecordSource for the form

If you want to edit information from AuthorsTBL, make a subform with
AuthorsTBL as its RecordSource

If you want to display information, you can use a dLookup function in
the ControlSource -- or, if you have a combobox whose RowSource includes
AuthorsTBL, you can include Publisher in a column and then display that
column in a claculated control like this:

=combobox_controlname.Column(#)

where # is the column index starting with 0 (zero)


Warm Regards,
Crystal

*
(: have an awesome day :)
*
 
hi

10s for the reply :)

10s community as well
--
oldLearner57


strive4peace said:
The ControlSource for each control, if it is bound to a table, must be a
fieldname in the RecordSource for the form

If you want to edit information from AuthorsTBL, make a subform with
AuthorsTBL as its RecordSource

If you want to display information, you can use a dLookup function in
the ControlSource -- or, if you have a combobox whose RowSource includes
AuthorsTBL, you can include Publisher in a column and then display that
column in a claculated control like this:

=combobox_controlname.Column(#)

where # is the column index starting with 0 (zero)


Warm Regards,
Crystal

*
(: have an awesome day :)
*

hi community

i had 2 tbl, helpDeskTBL and AuthorsTBL & both are related.
had already created a Form, helpDeskFRM based on helpDeskTBL
&
wanted to have a field name Publisher inside the helpDeskFRM so i used the
tool wizard to create an "unbound" field &
use the Expression Builder to create a bound field, =[AuthorsTBL]![Publisher]
but
when i return to the Form view, it shows #Name?

can anybody kindly guide me on this

10s!

10s community as well
Click to expand...
Click to expand...
 
Back
Top