how do i save or append the result of a form to a table

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

Guest

I have a form that calculates a certain number. I need to retrieve that
output and use it later in report. How do I save or append that record
 
create an append query that uses value from the form

First, what triggers that calculation?
Say it calculates after a user press a button.

Then in that button's VB code docmd.openquery "qrythatIjustcreated"

Hope this helps,
Restu Kresnadi
 
Thanks

rkresnadi said:
create an append query that uses value from the form

First, what triggers that calculation?
Say it calculates after a user press a button.

Then in that button's VB code docmd.openquery "qrythatIjustcreated"

Hope this helps,
Restu Kresnadi
Click to expand...
 
Hi, sorry to butt into a completed post but I have a similar problem where I
can populate a form from a query and I want to append the results into
another table but cannot manage to get the append query to see the form. Is
this possible?

Any help greatfully recieved.

Davie
 
well, the more important question here is *why*? if you have a form that is
bound to a query, then you have the underlying data in a table, correct? why
do you want to duplicate that data in another table? if you'll explain what
you're trying to accomplish, and what your tables structure is, probably
someone here can help you do it within normal relational design parameters.

hth


davethewelder said:
Hi, sorry to butt into a completed post but I have a similar problem where I
can populate a form from a query and I want to append the results into
another table but cannot manage to get the append query to see the form. Is
this possible?

Any help greatfully recieved.

Davie
Click to expand...
record
 
Tina, you are quite correct. I was trying something different when trying to
create an order form.
I have three tables, Customers, Order Details and Orders linked by c.Cust_id
- od.CustId and od.Order_id - o.Order_id.

I am trying to create an order entry form which will update the order table
and Order details table with the data input to the form. I know that single
table forms are ideal for data entry but not all fields are on one table and
I do not want to duplicate fields in different tables.
Would a subform acheive this?

Thanks for your reply.

Davie
 
yes, a subform would be a standard solution. mainform bound to tblOrders,
with perhaps a combobox control to pick the customer, subform bound to
tblOrderDetails - making sure the relationships are set and enforced in the
Relationships window.
c.Cust_id - od.CustId
Click to expand...

can the individual detail records of a single order belong to more than one
customer, in your business model? if not, i'm wondering why you have
customers records linked to directly to order detail records. ordinarily,
the customer record would be directly linked to the order record, with the
order record linked to order detail records; thus an *indirect*, but easily
traceable, link exists between customers and order details.

hth
 
Back
Top