Populating form with values from table/query not bound to form

J

Jinny M.

I am trying to set up a system in Access 2003 (Windows XP) in which
purchases are approved before they are made. I have a form-subform (which
works!) set up for entering the approval info. I would like to use the data
from the appropriate approval (which I can search for from a combo box) to
populate the relevant records in a purchase form/subform so that estimated
amounts can be changed to actuals & my budgets can be decremented accordingly
(& all the info does not have to be entered again). I might have to run a
query to get from my main form to my subform, since a single purchase or
purchase approval can contain many items. I have tried online help to see
what I can do with macro actions, but all of the references return "page not
found". Thanks!
 
Top