Copy Certain Data into new form

R

rattler0812

As part of two tables that remain uniquely separate, there is common
information between the two. However, is there a way that (when I fill in
the separate forms) that I can have the controls of Form A copy the similar
information into Form B? My goal is to have a command button that executes a
sequence of code that will (I hope) somehow copy the relevant information,
close the current form (Form A) and finally open a new and empty form (Form
B) with only that similar and relevant information already filled in.

Is that possible? Or am I getting a little lofty in my expectations?

Rattler
 
S

SteveD

I'm not really getting the picture your painting.
If the essence is you want to copy selected data from Form A (table A) to
Form B (table B), then one way is to use an append query from table A to
table B. Then when you open form B, the "new" data will be there. Are you
looking to open form B from form A, which is possible with a command button,
but do it after the append query. (the same command butoon would do both)

Is this what your looking for?

SteveD
 
R

rattler0812

I am not necessarily trying to open form B from form A. It is more of
copying the specific data from table A into table B, after filling form A, so
that when I do open Form B, the basic information and linked information is
already available on the form. Is that making this more complicated than it
really needs to be?

Rattler
 
S

SteveD

Hey Rattler0812,
An append query would work. It may be "triggered" when you close form A
with an OnClose event. It would help to have a criteria, like the current
date or something else (check box) so that you only copy the new records. I
have used both approaches before. The checkbox approach, I used two queries,
1) copies over all items where the checkbox is false, then 2) updates the
checkbox to be true (where checkbox is false).

Does that give you a place to start?
SteveD
 
Top