How do you.......

[Mark Lees]

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?

[Mike Storr]

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?

[Mark Lees]

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 Storr]

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

[Mark Lees]

"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

[Mike Storr]

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