show a value of a form,query or table in the other form

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

Guest

Please I want use or show a value of a field of a closed form (other form) on
the open or current form in a text box.
 
You can't refer to a field in a closed form, instead refer to the field in
the table using DLookUp

=DlookUp("[Fieldname]","[TableName]")

Look at the help file for addition example on how to add a criteria, if
needed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Parameter Value error in a Subform 0
Access Access Report Works on One Machine but not Another 3
Access Sub form opens before the main form in MS Access 0
Setting default value property in form 1
Querying Multi Line Text Box in MS Access Forms 0
Query Parameter using multiple options 0
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3

Back
Top