Copy Certain Data into new form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top