A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms retain a value



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2008, 04:56 PM posted to microsoft.public.access.forms
Rpettis31
external usenet poster
 
Posts: 96
Default Forms retain a value

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.
  #2  
Old April 15th, 2008, 06:16 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default Forms retain a value

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.

"Rpettis31" wrote:

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.

  #3  
Old April 15th, 2008, 06:37 PM posted to microsoft.public.access.forms
Rpettis31
external usenet poster
 
Posts: 96
Default Forms retain a value

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

"Golfinray" wrote:

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.

"Rpettis31" wrote:

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.

  #4  
Old April 15th, 2008, 09:38 PM posted to microsoft.public.access.forms
Kc-Mass
external usenet poster
 
Posts: 362
Default Forms retain a value

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


"Rpettis31" wrote in message
...
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

"Golfinray" wrote:

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.

"Rpettis31" wrote:

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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.