Forms :: Copy Data From Record In SubformA To SubformB?

Apr 22, 2013

I would like my users to be able to view stock items in one (sub)form and when they double click on an item, then certain data is copied to an orders (sub)form.

I have therefore embedded two unbound subforms into a master form.

The master form (Frm Stock) has no fields, but it has 2 subforms.

Frm_Stock_Subform and Frm_OrderDetail_Subform

So I have 2 problems here.

Problem 1:I would like the following code trigger when the user double clicks anywhere on the record that the user wants to order.Thus far, I can only make it fire only when the user doubl;es clicks in a specific field (in this case, the ID field is the trigger)

Problem 2:I cannot activate the Frm_OrderDetail_Subform in order to create the new record. (I have looked at this link - Refer to form and subform

Code:
Private Sub ID_DblClick(Cancel As Integer)
On Error GoTo Err_ID_DblClick
Dim MyOrderID As Variant
Dim MyStockID As Variant
Dim MyAmt As Variant

[code]....

View Replies


ADVERTISEMENT

Adding Date From SubformA To SubformB

Nov 11, 2005

Hi All,
I am not sure where to go with this. I have tables Employee, Audio, evaluate.
My main form opens with recordsource = Employee. SubformA is tblAudio linked via empID. I have subformB that is tblEvaluate linked via EmpID.

SubformA is set as contineous form, so there may be 1-?? records per that Employee. I have a command button on subformA next to each record. What I would like to do is: when clicking on the command buton of that record copy some of the fields (of that record only) over to subformB appending or editing tblEvaluate.

I have tried to search through the postings but no luck on anyone discussing what I am trying to do.

Any help would be greatly appreciated....

thanks...Enviva

View 4 Replies View Related

Forms :: Copy Data To New Record

Jul 4, 2014

Currently I have created a data base and form. I am at a point where I need to copy data from one record specific field to a different field in the new record all while creating a new record.

Create a new record

Copy field in LastWeekInfo current record
to
New record ThisWeekinfo field

View 3 Replies View Related

Forms :: Copy Record Data To Another Table Through Form

Aug 1, 2014

I have a form with 2 subforms, each based on their own table. One displays categories of invoices (e.g. rent, electricity, etc.) including some details like monthly costs.

I would like users to be able to select one of those categories and copy this to another table, after which they can enter on what date the invoice was paid, to make a history of payments.

At first I based fields in the history table on fields in the categories table so that you could simply pick a category from a combobox. I had an after update event on that combobox that also automatically set the 'costs' combobox to the matching price.

Worked fine, but had one snag: if I update the costs of a category in the categories table (e.g. the rent goes up) then all the costs in the history table was also updated because the fields got their info from that table.

So now I no longer have field from the history table based on the other table, and want to use 'set value' to copy values from one table to the other. I'd like the user to be able to somehow select a category with a single click on a button, and getting the info for that category copied. However, how can I get access to know from which record I want the fields copied?

Or is there a completely different way to get a history of payments that works much better?

View 4 Replies View Related

Forms :: Timestamp Record After Update Event And Copy Data Into Another Form?

Oct 2, 2014

I have a simple data entry form on which there are about 30 to 40 data fields to be update by users. One of the field is called "Stage" which is a combo box with 2 entries "Formal Case" and "Informal Case" with no default value whien a form is first opened.

Users will normally create a data entry which updates the table and save.

However if in future users open any one existing record and try to change Stage field from Informal to Formal or vice a versa I would then like this action to

1) update a time stamp concatinated with the stage change value in a text field perhaps

2) save/close the form

3) open a new form with all the existing entries(plus changed status of "Stage Field") with a new record ID and new time stamp.

View 1 Replies View Related

Copy Some Data From Previous Record To Next

Apr 12, 2006

Hi
I need to copy some data from last record to next(New record), when a user clicks a button on a form. I don't want to copy all the data.

An example would be booking in items from an invoice:
Company would be the same
Invoice number would be the same
Product code would be different
quantity would be different

Hope this makes some sence, and i'm not being stupid:rolleyes:

Andy

View 1 Replies View Related

Forms :: Copy Existing Record To New Record?

Dec 24, 2013

I have the employee data record... I want copy of the same record to insert in table but with different employee id and Site through forms. StaffNo is the primary key.

For example

existing record
StaffNo, Site, Name, hiring date, etc
AKA-111, 10, John, 25-10-13

new record
StaffNo, Site, Name, hiring date, etc
ALM-123, 14, John, 25-10-13

View 13 Replies View Related

Copy Field Data From Main Form To A Subform On Add New Record

Feb 25, 2006

I have a main form that has some sub forms on it linked by master child on PK. When I select a new record on the sub forms I want to take a date value from the main form and populate the value into a field in the sub form. How do I do this as I cannot see a new record event on the sub form?

help would be much appreciated.
regards

Peter

View 7 Replies View Related

Forms :: How To Copy Fields From 1 Record To The Next

Aug 6, 2013

I have fields on a form for the Date, the Start time and the Finish time. These won't change for the next 120 records. So, upon opening a new record, I'd like the Date and times to appear there already. But here is the crux: After about 120 entries, the date and Time changes, for the next 120 entries. So, once the 'batch' is finished, or I close access, the values do not need to be remembered until I enter a new record.

I copied something like the following from a book and tried running it with various modifications, just for the Date to start with, but no luck. (It did strike me as too simple for something, clearly, as unbelievably TRICKY as my problem...) I did find quite a few posts on this here but none seemed to work for me, or made sense to me in the slightest. (I did mention that I'm a complete rookie, didn't I?)

Private Sub Acquired_date_AfterUpdate()
Me!Acquired_date.DefaultValue = "'" & Me!Acquired_date.Value & "'"
End Sub

View 7 Replies View Related

Forms :: Copy From Previous Record?

Jun 2, 2015

I found and pasted some code which copies records from the previous record on the form. Seems to work well, but I was wondering if there is an issue with the copying of the first field which is a combo box?

View 10 Replies View Related

Forms :: Copy Record Within The Subsorm

Mar 26, 2014

I have uploaded a small database. I keep track of payments for people who receive a language proficiency allowance. Usually the members receive this allowance for two years. Sometimes they receive it for one year.

Lang Level DateQuaFrom DateQuaTo DatePd From DatePd To
Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-12 14-Dec-13
Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-13 14-Dec-14

There is a field called NoOfPays . If this field value is 2 in the first record then I want it to insert a second record as shown above. How do I do it. I tried to append but it is not working.

Now copying the record with the maxID is not correct.

View 7 Replies View Related

Forms :: Using Combobox Value To Copy Whole Record?

Dec 3, 2014

Let's say, I'm updating a record, and I have a combo-box that says transfer and another combo-box that states "where to?" - or words to those effect.

Each record has a field for credit value and a field for debit value.

When I've finished entering the current record, I want to run code that fires the event, so, copies all the data from one record, to create a new record, BUT...

1) changes the "where to" from the old record to "From" in the new record.
2) changes either the credit or debit value, to the opposite in the new record?

I would like to do this from a sub-form. I can copy a whole record, no problem, but can't seem to change field values.

View 2 Replies View Related

Forms :: Copy Record Button - Command Or Action Isn't Available?

Jan 13, 2014

I've rebooted my copy record button and just used the macro wizard for now, it seems to work as far as I can tell but there is something strange about it.

I've added in some text boxes so I've got some confirmation, but when I click this copy button I get the following error;

"The command or action 'RecordsGoToNew' isn't available now."

View 1 Replies View Related

Forms :: Copy Record On Form Based On Combo Box?

Mar 31, 2014

I have a form that i input information into. I have a combo box labeled Addendum, you can select "yes" or "no". What i would like to do is if user selects "yes" then a new record needs to be copied with exact information form original, with the excpetion of a field labeled "tape review #" 1403310000 for example. "-AD" needs to be added to this new record after the review number. Also the field "tape review #" is indexed not to allow duplicate numbers.

View 1 Replies View Related

Forms :: Copy Data From On Field Into Another

Jan 10, 2015

I would like to copy the Data from the field PORTFOLIO CODE into the field BUYSELL.

I would like to copy the CURRENCY Data in the field STOCK EXCHANGE into the field CURRENCY

We use MS Access 2007.

View 1 Replies View Related

Forms :: Copy Data From One Field To Another?

Jun 20, 2014

I have a single table / single form on the form we are entering amounts in two fields

Split Net Values
Total Net Value

We then have a further two fields

Split Gross Value - which is a calculated field based on Split Net Value plus 20%
Total Gross Value - which is a calculated field based on
Total Net Value plus 20%

I have a further two fields

Actual Split Gross Value
Actual Gross Value

I need to copy the Split Gross Value into the Actual Split Gross Value but still be able to amend the figure.

Also need to copy the Total Gross Value to the Actual Gross Value and yet again be able to amend the figure.

View 4 Replies View Related

Forms :: Copy Data From A Form To Another

Jun 4, 2013

I've got a database for safety accidents/incidents. I've a table for incidents and another for employers with fields:

tablename:tblEmployers, formname:frmEmployers
EmpID
FullName
EmploymentDate
BirthDate

In the Incidents form, i've a button which loads the frmEmployers with datasheet view.

Is it possible, by clicking/dbclicking on specific employer, his data (empid, fullname, etc) to autofill/copy to the same fields in form of incidents and save the record?

I've tried with combobox selection(Employers fullname) and autofield, but record didn't save the autofill data.

View 4 Replies View Related

Forms :: Copy Record From Previous Field If No Specific Combobox Value

Oct 30, 2013

I have an access form that needs filling in daily by various people.

It's to document changes to a website and I currently have a combobox box set up for the various sections to state whether they are AMENDS, REVERTS or NO CHANGE.

I have set conditional formatting to then highlight these sections but am also trying to get it to work so that if the user chooses "NO CHANGE" then the data for that field copies over from the previous record.

I have set this up in the AfterUpdate code for the combobox, but nothing is happening, not even an error....

Code:
Private Sub COMBOBOX1_AfterUpdate()
If Me.COMBOBOX1 = 3 Then
Me.[FIELD_TO_CHANGE] = DLookup("[FIELD_TO_CHANGE]", "tb_TABLE", "[ID]=Forms![form_FORM]![ID]-1")
End If
End Sub

(Where 3 is the value of NO CHANGE in the combobox, and FIELD_TO_CHANGE, tb_TABLE and form_FORM being the names of the various elements)...

View 1 Replies View Related

Forms :: Copy Data From Combo Box To A Field

Jan 5, 2015

We have been trying to copy data from a combo box to a field without any success.

===
Private Sub PortfolioCode_AfterUpdate()
' From the combo box "PortfolioCodek" Place the field data into Column # 1
Me.PortfolioCode = Me.Broker.Column(1)
End Sub
===

View 4 Replies View Related

Forms :: Copy Data From FormA To FormB

Nov 18, 2013

I have a data entry formA which has a number of combo boxes and date and time fields. In some cases the user will have to enter data into formB where many of the fields are repeated. I've created a button in formA which opens formB, I'd like this button to autopopulate some fields from formA as well.

These forms feed data to 2 different tables in the database. I've tried using

formB![fieldname]=Me![fieldname]

with no success. I'm using Access 2010

View 2 Replies View Related

Forms :: How To Copy Unbound Text Box On Form To A Current Record In Table

May 17, 2015

I created an unbound text box on a form that automatically pulls the current logged in user by using this:

Private Sub Txtuser_Click()
Me.Txtuser = Environ("Username")

The form grabbs the logged in user with no problems, however, I ultimately want this information to also end up in my table. So the form has three boxes (to keep it simple). The user will type their first name and last name manually on the form which the record source is this "table" where their name goes to the table last name =Field 1 and first name=Field 2 respectively. I want the unbound box from the form to place the logged in user in Field 3 for the current record.

View 5 Replies View Related

Forms :: Creating A Form Which Copy Selective Entries From Previous Record

Dec 10, 2013

I am tasked with creating a scientific database of fish catches at various different sampling stations. I envisage the entry form having hierarchy levels, ie year, season, date, sample station, species caught, and then the specific associated data with each species (weight, abundance, length etc) will form each distinct record.

In each year there are 2 sampling seasons. In each sampling season there are up to 20 dates on which samples are taken. On each date there are up to 50 sample stations recorded. And at each station up to 20 species can be recorded.

In order to enter each species caught in a survey, the end user will potentially have to fill the season box with an entry 40,000 times. For each season there will be 20,000 date entries to be made. For each date, 1,000 station code entries, and 20 species entries for each station. What I would like to happen is this.

When the end user is entering the data, he or she will be working through the hierarchy from the ground up. Ie., they will enter a particular species' data (abundance, weight, length etc) at a particular station on a particular date during a particular sampling season. The next entry will be a different species at the same station on the same date during the same season. I would like the duplicated information from the previous record to be copied across onto the new one so that all the end user has to do is enter the species name, abundance weight and length data.

Once they have finished entering all the species data for that particular site, they can move onto the next site which they would fill in the data themselves for the station code. So, in the hierarchy, the first button would copy all the previous data except the species name and associated weight length abundance data. The next button would do the same, except leave the station code blank. The next button would leave the species name, station code and date blank. And so on up the hierarchy. The end user would be able to selectively choose which data is copied over by using these buttons, saving lots of potential extra work doing repetitive entries.

View 1 Replies View Related

Forms :: Subform Data To Copy Itself Into Main Form

Oct 23, 2013

I have an unbound subform within a main form that i add data to.

Once I click save to save all the data the subform data will save itself into tblPerson and the main form data will save itself in tblSupplier.

The tblPerson will have an autonumber for the whole record, i need this autonumber to save in tblSupplier, only this autonumber.

View 5 Replies View Related

Forms :: Copy Form Data To Report After Change

Feb 19, 2014

I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report.

I have tried searching this forum and other but not quite sure of the terminology so not getting good results.

View 2 Replies View Related

Forms :: Copy Field Data From Form To Subform

Jan 9, 2014

I have a form puling from one table and then a subform in that form pulling from another table.I have a field in the [FORM] called [GROSS REFUND] and a field in the [SUBFORM] also called [GROSS REFUND].I want the value of [FORM].[GROSS REFUND], if the value is not zero, to be copied into a new record on the [SUBFORM.[GROSS REFUND].

View 3 Replies View Related

Function From FormA Sets Combo Box Value On FormB But Does Not Update SubformB

Feb 21, 2006

I have two forms (FormA, FormB) with combo boxes (cboA, cboB) that control the record being shown in the subforms (SubformA, SubformB). I have written code and attached it to the "AfterUpdate" function on the combo boxes and this works perfectly.

Here's my problem....

I have a button on FormA that, when clicked, opens FormB, assigns the value in cboA to cboB and closes FormA. Unfortunately, I can not figure out how to have SubformB automatically update based on the new value assigned by code to cboB.

I've tried .Requery, "After Update/Change/Dirty/etc." on cboB, "OnOpen" on FormB, and moved the code from cboB "AfterUpdate" to ButtonA "AfterClick" and nothing seems to work.

I need the user to use buttons to navigate through various forms displaying information for the same record. I also need to give the user the option to switch the record using the combo box. Does anyone know how to do this? Is it possible to use code to update the value in a combo box and then have the record in the subform automatically change?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved