Moving data from one form to another automaticlly

[Charirty Case]

We area non for profit org that fullfills wish lists for children infected
/affected by HIV
we have a access datbase that tracks all the requests and needed information
per child
What our issue is
we would like to do is once the request is fufilled is there a way to move
the data to another subform without retyping all the information of the
request again?
this is all done with subforms is it at all possible?

 

[Douglas J. Steele]

Forms are usually just "windows" into tables (the exception would be unbound
forms). As such, you can display the same information on as many different
forms as you like by pointing to the same table(s).

 

[John Spencer]

If you have a field that indicates that the request was fulfilled, then you
just filter the first subform to show records where requests have not been
fulfilled and the second subform to show records where requests have been
fulfilled.

How you filter will be based on the field type of the "fulfilled" field. If
the field is a date then you would create a query where fulfilled is null to
get the requests that are not fulfilled and another query where fulfilled is
not null to get the requests that have been fulfilled.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Charirty Case]

John
Wow thats sounds like it will work for a temporay fix
BUTwhat we are trying to do is
we have to keep a record of all items both requested and the subsituted or
additional items we given to each child
thats why we have the two tables one called requests the other called gifts
the subforms come from each table so that is why we need along term fix
basiclly moving the information from one table to another

 

[John Spencer]

Well, you can use an append query to transfer the information from Requests to
Gifts and a delete query to remove the information from Requests.

My personal preference would be to mark the record in Requests as moved and
keep it in the Requests table - if you move it you no longer have a record of
the request.

The SQL qould look roughly like the follwoing
INSERT INTO Gifts (<<List of Fields>>)
SELECT <<list of fields>>
FROM Requests
WHERE Requests.PrimaryKeyField = <<< Some specified value >>>


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County