easy- #name? on forms

[aperture]

hello

can anyone help a beginner out with what '#name?' siginifies in a text box? and what i might to do remove it? the form's recordsource is a query containing the problem fields, and their names are spelled correctly in the query fields, so i dont undersatnd why im receiving this. any ideas?

thanks!

aperture

 

[UncleJack]

You usually get this from Access being unable to resolve what you intend for the record source of a text box. For example, reference to a field that doesn't exist, or to a function with an equal sign in front of it.

Uncle Jack

 

[tempclerk]

Or if the name of the textbox is the same as the name of the field.

 

[tempclerk]

Make that "if the control source of a textbox named the same as a field is changed (i.e. the control source seems to refer to the control itself)."

 

[aperture]

thanks tempclerk, uncle jack

in a related development-

will i have a problem updating the form's recordset if the record source is a query? my other alternative is to make subforms out of the various groups of fields on the form and to make the recordsource the form's own table. i have a monstrous number of fields queried out, and i also have a similar prolem as someone else in another thread-the recordset is not updateable, and needs to be.

any ideas?

thanks!

aperture

 

[UncleJack]

You may have trouble updating if your data source query is multi-tabled. Many queries that join tables create recordsets that can't be updated because they're ambiguous. You can sometimes get around this by adding all the fields ( * option) of the table to the query.

Perhaps you could consider simplification of the amount of data being presented on a particular form by using subforms to display (and update) discrete areas of data. I like using tab controls populated with subforms. The data source for the subform can usually be a single table or single table query making life so much more simple.

Uncle Jack