unbound control

[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

 

[strive4peace]

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
*

 

[oldLearner57]

hi

10s for the reply

10s community as well
--
oldLearner57

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

 

[strive4peace]

you're welcome happy to help

Warm Regards,
Crystal

*
have an awesome day
*