from field in form to another form.

[feeman]

What I am looking at doing is I have a couple of forms, when I enter
the number of products been despatched on the order form, it then
creates a record in the transaction table and also the product
history. I have created a couple of update queries which worked well,
but did not perform the way that I wanted them to.

I wanted to do it using code so that when the despatch order button is
pressed it creates the above.

The information of the order is in a sub form called Order details on
a form called orders., this then wants to create a record in the form
transaction history, and another in the product history. I have tried
to work on the code but to no avail.

sort of looked like this.

Forms!transaction history.form![qty required] = forms![order details].
[qty despatched]

Were it takes it from the field qty despatched on the order form in
the order details sub form and puts it into the form transaction
history in the field qty required.

I am looking for help on the coding part ie what are the parts made up
of i.e. what each part of the code relates to in respect of what it
isd doing.

Any help much appreciated if you can understand what I am trying to
get at. Please Help,

[jahoobob via AccessMonster.com]

A form is just a way of viewing/editing/adding data and doesn't store
anything. You can view what you change in one form on any other form, so
that if you enter a number in despatched in one form you can view it another
form and label it required. You don't want to double enter data. I would
guess that you have a way of identifying the product in both forms and it
would be a common ID number.

feeman wrote:

>What I am looking at doing is I have a couple of forms, when I enter
the number of products been despatched on the order form, it then
creates a record in the transaction table and also the product
history. I have created a couple of update queries which worked well,
but did not perform the way that I wanted them to.

I wanted to do it using code so that when the despatch order button is
pressed it creates the above.

The information of the order is in a sub form called Order details on
a form called orders., this then wants to create a record in the form
transaction history, and another in the product history. I have tried
to work on the code but to no avail.

sort of looked like this.

Forms!transaction history.form![qty required] = forms![order details].
[qty despatched]

Were it takes it from the field qty despatched on the order form in
the order details sub form and puts it into the form transaction
history in the field qty required.

I am looking for help on the coding part ie what are the parts made up
of i.e. what each part of the code relates to in respect of what it
isd doing.

Any help much appreciated if you can understand what I am trying to
get at. Please Help,

--
Message posted via http://www.accessmonster.com

[feeman]

Iunderstand that the forms are just for viewing/editing and adding
data, but this way does not actually duplicate the records it creates
a record with different information, gained from the original records.

Orginial record has the following on
stock ID
Stock Location
Qty Despatched

Transaction table has
date
action
stock id (from original stock form)
qty (from original stock record)

so from the original stock record I would like to take the sotck id
and qty and put it into the transaction form, date will be
automatically todays date and the action will be standard as of the
order record it will be a despatch and of the delivery note it will be
a delivery.

So I am trying to get the information from one form onto the other and
the this will automatically update the table .

[jahoobob via AccessMonster.com]

I think you are doing inventory. Take a look at the Northwinds sample
database that ships with most versions of Access. It has an inventory
component.

feeman wrote:

>Iunderstand that the forms are just for viewing/editing and adding
data, but this way does not actually duplicate the records it creates
a record with different information, gained from the original records.

Orginial record has the following on
stock ID
Stock Location
Qty Despatched

Transaction table has
date
action
stock id (from original stock form)
qty (from original stock record)

so from the original stock record I would like to take the sotck id
and qty and put it into the transaction form, date will be
automatically todays date and the action will be standard as of the
order record it will be a despatch and of the delivery note it will be
a delivery.

So I am trying to get the information from one form onto the other and
the this will automatically update the table .

--
Message posted via http://www.accessmonster.com