Display Information From Another Form In a Control

  • Thread starter Thread starter ksenya.lim
  • Start date Start date
K

ksenya.lim

Hey,

My problem is that I want a few controls on my form display
corresponding record from controls placed on another form (forms are
based on 2 tables, one-to-many relationship, control source
=[Forms]![FormName]![ControlName]). It worked before when the 2 forms
were open at the same time. Now when one form closes and another opens
all i get is #Name. Is there any way to solve this problem? Thanks a
lot!
 
Of course you wouldn't be able to read from a closed form! The form does
not hold data itself, it merely hosts data while it is open. What you
should do is read the data directly from the table it is stored in. Most
likely, all you need is a DLookup function (look it up in Access help).

HTH,
Nikos
 
Thanks a lot! I used the DLookup function and it worked perfectly!
 
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

Parameter Value error in a Subform 0
Referencing Subform Controls/Properties 2007 3
Displaying information in one form related to info in another form 2
Referring to form control 3
open one form from another but display same record information 3
Trying to add a field from another table on a form 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Display control for few seconds 5

Back
Top