Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Forms retain a value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rpettis31 - 15 Apr 2008 16:56 GMT
I open another form from a master form.  I pass values with setting the slave
form like fields equal to the master.  The question I have is how do I retain
the value without having to open the master form.
Golfinray - 15 Apr 2008 18:16 GMT
Forms are the one side, subforms are the many side. The subform has to be
linked to the mainform (properties, data, link master and child fields.) That
value is set in properties so it will stay there and be there anytime the
form is opened. You will not normally be able to use the subform without
first using the one side on the mainform. If you want just one or two lookups
on the subform you might use a combo box to get those.

> I open another form from a master form.  I pass values with setting the slave
> form like fields equal to the master.  The question I have is how do I retain
> the value without having to open the master form.
Rpettis31 - 15 Apr 2008 18:37 GMT
I probably used the wrong terms as this is not a sub form it is more like a
follow up form that uses some of the information on a first contact form.  
One the initial information is populated on the follow up form the first
contact form is not needed.

That is what I am having trouble with.  How would a combo box work in this
instance?

Thanks

> Forms are the one side, subforms are the many side. The subform has to be
> linked to the mainform (properties, data, link master and child fields.) That
[quoted text clipped - 6 lines]
> > form like fields equal to the master.  The question I have is how do I retain
> > the value without having to open the master form.
KC-Mass - 15 Apr 2008 21:36 GMT
Store the values in an array or a collection of variables or a table or copy
them from the first form to the second when you close the first.

Regards

Kevin

>I probably used the wrong terms as this is not a sub form it is more like a
> follow up form that uses some of the information on a first contact form.
[quoted text clipped - 20 lines]
>> > retain
>> > the value without having to open the master form.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.