By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

How do you.......

P: n/a
I have a database that will be using 2 forms to collect data (A & B).
On form B 4 dates will be entered. I would like those 4 dates to
apppear/load/initalize/import in form A. What is the best way for a
novice Access user to set this up?
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
This will depend on how form A is opened, wether or not form B stays open.
The absolute simplest way is to set the "Default Value" property to
refference the appropriate control on form B. (ie =Forms!FormB!Control1)
This will require that form A can only be opened while form B is open. B
does not have to be visible, but it does need to be open. If this does not
work for your situation, then more details would be required.

Mike Storr
www.veraccess.com
"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
I have a database that will be using 2 forms to collect data (A & B).
On form B 4 dates will be entered. I would like those 4 dates to
apppear/load/initalize/import in form A. What is the best way for a
novice Access user to set this up?

Nov 12 '05 #2

P: n/a
Mike:

Thanks for responding. The problem with this solution is that both
forms will rarely be open at the same time. So Form A has to be able
to open regardless if B is opened. Thanks.


"Mike Storr" <no****@somewhere.con> wrote in message news:<_P*****************@news20.bellglobal.com>.. .
This will depend on how form A is opened, wether or not form B stays open.
The absolute simplest way is to set the "Default Value" property to
refference the appropriate control on form B. (ie =Forms!FormB!Control1)
This will require that form A can only be opened while form B is open. B
does not have to be visible, but it does need to be open. If this does not
work for your situation, then more details would be required.

Mike Storr
www.veraccess.com

Nov 12 '05 #3

P: n/a
If form A can be opened without B being open, then you can't move dates from
one to the other. They will have to be stored elsewhere ( temporary table
maybe ) and then retrived with form A. B does not need to stay open, it only
needs to be available while A opens. Once this is done B can close.

"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
Mike:

Thanks for responding. The problem with this solution is that both
forms will rarely be open at the same time. So Form A has to be able
to open regardless if B is opened. Thanks.


"Mike Storr" <no****@somewhere.con> wrote in message

news:<_P*****************@news20.bellglobal.com>.. .
This will depend on how form A is opened, wether or not form B stays open. The absolute simplest way is to set the "Default Value" property to
refference the appropriate control on form B. (ie =Forms!FormB!Control1)
This will require that form A can only be opened while form B is open. B
does not have to be visible, but it does need to be open. If this does not work for your situation, then more details would be required.

Mike Storr
www.veraccess.com

Nov 12 '05 #4

P: n/a
"Mike Storr" <no****@somewhere.con> wrote in message news:<6N********************@news20.bellglobal.com >...
If form A can be opened without B being open, then you can't move dates from
one to the other. They will have to be stored elsewhere ( temporary table
maybe ) and then retrived with form A. B does not need to stay open, it only
needs to be available while A opens. Once this is done B can close.

"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
Mike:

Thanks for responding. The problem with this solution is that both
forms will rarely be open at the same time. So Form A has to be able
to open regardless if B is opened. Thanks.


"Mike Storr" <no****@somewhere.con> wrote in message

news:<_P*****************@news20.bellglobal.com>.. .
This will depend on how form A is opened, wether or not form B stays open. The absolute simplest way is to set the "Default Value" property to
refference the appropriate control on form B. (ie =Forms!FormB!Control1)
This will require that form A can only be opened while form B is open. B
does not have to be visible, but it does need to be open. If this does not work for your situation, then more details would be required.

Mike Storr
www.veraccess.com


Mike - What about building a query to include
all of the data from form A's Source table and the 4 date fields from
Form B's source table. Then set that query as the record source for
Form A.
Mark
Nov 12 '05 #5

P: n/a
That's what I meant by storing them elsewhere, however you'll need a way to
find the ones you want. If these dates change values or places frequently
(ie. new records) then you may find it difficult to get the last ones
entered in a multiuser environment.

If this pdb is running on one machine only, then another option is to use an
Array, or 4 variables that are public to the project. Assign the values when
form B closes, and A can retrive them whenever it opens, this would always
keep the last entered dates available.

Mike Storr
www.veraccess.com
"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
"Mike Storr" <no****@somewhere.con> wrote in message

news:<6N********************@news20.bellglobal.com >...
If form A can be opened without B being open, then you can't move dates from one to the other. They will have to be stored elsewhere ( temporary table maybe ) and then retrived with form A. B does not need to stay open, it only needs to be available while A opens. Once this is done B can close.

"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...
Mike:

Thanks for responding. The problem with this solution is that both
forms will rarely be open at the same time. So Form A has to be able
to open regardless if B is opened. Thanks.


"Mike Storr" <no****@somewhere.con> wrote in message

news:<_P*****************@news20.bellglobal.com>.. .
> This will depend on how form A is opened, wether or not form B stays

open.
> The absolute simplest way is to set the "Default Value" property to
> refference the appropriate control on form B. (ie =Forms!FormB!Control1) > This will require that form A can only be opened while form B is open. B > does not have to be visible, but it does need to be open. If this
does not
> work for your situation, then more details would be required.
>
> Mike Storr
> www.veraccess.com
>
>


Mike - What about building a query to include
all of the data from form A's Source table and the 4 date fields from
Form B's source table. Then set that query as the record source for
Form A.
Mark

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.