Field On Subform Link With Form
Nov 28, 2005
hi
i have a form just like customer orders in Northwind
with 2 subforms
Subform1 is showing orders number and i want to add something on that
subform 2 is products that ordered !
i want to add something on subform1 that if i Dbl Click on orderID field
it will sho for example another Form "orders"
i'm trying this code but i can't do it
Private Sub OrderID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "orders"
stLinkCriteria = "[OrderID]=" & "'" & Me![OrderID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit Sub
End Sub
would u please help me
View Replies
ADVERTISEMENT
Jan 5, 2012
Seems like nothing I have so many questions today.
I have a main form and a sub form. The main form have a command button where when I clicked, the Sub form text fields should be empty or cleared.
How do I refer to that of subform from the main form?
This is what I have now and its not working.
Code:
Me.Forms![frmAuditAddNewMain]![frmAuditAM].Form!Text123 = ""
View 3 Replies
View Related
May 31, 2006
I have a form/subform that I want to link together using a memo column, yet when I try Access tells me that the column datatypes are incompatible. I've even tried making both the form's and subform's recordsource be the same table. Any idea how I can do this?
View 6 Replies
View Related
Jun 26, 2005
Hi every body. i made a bounded data entry form that is based on a form and a sub form. But when i try to run it i get many errors. I be happy if some one help me how i link these two tables since draging the sub form to the form did not establish the reletion automatically! I be happy if some one teach me how to link form and sub form together. Below u can see the two query which is for the main form and sub form.thanks
http://i5.photobucket.com/albums/y180/method007/constraint.jpg =====> table reletionships pic
QTimeKeepingemployeno,name ==>query
Code:SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpNameFROM dbo_Employee;
subform query:
Code:SELECT dbo_Hours_worked.*, dbo_Task.descriptionFROM dbo_Hours_worked INNER JOIN dbo_Task ON dbo_Hours_worked.Task = dbo_Task.taskcode;
View 1 Replies
View Related
Oct 24, 2005
Hi,
I have set up a database for my company which holds records to all the companies that we have as clients. I have created a main form and a subform. The main form is where all the particulars of the companies are entered, and the subform is like a preview window of the companies. By right, when i click on one of the records in the subform, it should reflect in the main form, enabling me to add on additional information using the fields in the main form (i have some features in the main form that should be used to record the informatio), but I just do not know how to go about doing that. is there a way to link the subform to the main form, such that when i click on the past records in the subform, it will reflect on the main form for me to edit? Any help is appreciated.
View 6 Replies
View Related
Jul 13, 2013
I have a form (frmAddBeaterToShootDay) with a subform (frmChooseBeaters). I want the subform to show all the records of all the beaters in the contact list, which it does. I then want to be able to tick the box (AddToShootAsBeater) and associate that person with that record on the form (frmAddBeaterToShootDay).
When I go to the next record on the form (frmAddBeaterToShootDay) again I want to show all the beaters on the subform but all the tick boxes in (AddToShootAsBeater) should be blank until I tick the required ones.
I think I should be doing this as a Many to Many relationship which I have done from (tblContacts) (tblShootBeaters) (tblShootDates).
The problem is when I put all three tables in the query I get no results in the subform!
View 1 Replies
View Related
Dec 16, 2013
I have a form containing company records. In a subform I have contact records for individuals in each company.
Each of those individuals has a child table for adding contact notes (telephone, email). I want to add a button to the subform to open a new, separate form so I am able to add notes.
I used the wizard to create a link button but I get
Code:
Syntax error in query expression
So does Access assume the button is opening from a form rather than a subform or does it not matter? Is there something I need to change to the following code?
Code:
stDocName = "Form_Companies_Notes"
stLinkCriteria = "[Company_contact_ID]=" & Me![Company_contact_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
View 3 Replies
View Related
Apr 2, 2013
I have a form (frmAddManifest) with a subform (subfrmManifestTransporters).
When creating a new record, I can enter data into frmAddManifest, but the subform doesn't update to link with the record - I presume it's because the record from the main form hasn't been completed yet.
Is there a way to requery the form and/or subform so it stays on the record I was working on, and link the subform properly?
View 4 Replies
View Related
Apr 1, 2013
I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products.I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly sold by the Supplier.Have dabbled in SQL as follows:
SELECT Products.ProductID, Products.ProductName
FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID
WHERE ((Stocksubform.SupplierID=Stock.SupplierID))
ORDER BY Products.ProductName;
View 2 Replies
View Related
Jun 13, 2005
Hello,
I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded.
Is there a setting on the parent form that also has to be changed, to make the new binding?
Thanks,
Aleksander
View 1 Replies
View Related
May 17, 2006
I have a main form (parents and their grant applications) and a subform (children). The information for each is stored in three seperate tables. The parents and children are linked in the relationships via ParentID (one to many). The parents are linked to the applications via ApplicationID.
I have a query which links parents and applications, this query is the recordsource for the main form. The subform is a query of just the children table. The problem I am having is that the subform doesnt seem to be linking to the main form. When I add the details of a new parent/application the ParentID doesnt automatically show on the subform. And I get 'automation object' errors.
View 1 Replies
View Related
Jul 18, 2013
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
View 10 Replies
View Related
Aug 19, 2015
I am currently stuck on set focus property. I have a main from with nested subform. I am trying to move the focus from last field of the subform to another field on the main form.
Customers(mfrm)....>Addresses(sfrm)...>Orders(sfrm Add)......>OrdDetails(sfrmOrders)
Now I have a field name [Securedesign] in frmOrderdetails and I want the tab order to navigate to field [CustomerID] in frmAddresses which is a subform to frmCustomers.
View 2 Replies
View Related
Feb 12, 2015
I have a main form and a subform.
Both forms have the field called JobID in common.
Both forms have a field called JobStatus.
Any easiest solution so that After I Update the field called JobStatus in the subform, it changes the field called JobStatus in the main form to the value which was selected from the subform?.
View 3 Replies
View Related
Oct 24, 2005
hi, i would like to be able to prevent a user from being able to change a field (lock a field) in a main form if a field in a subform is complete. (the field in the subform is named: "new_weekly_base" if this is complete then i would like the field: "weekly base" to be locked on the main form. is this possible?, please help.
the main form is named: "SCREEN-MAIN"
the subform is named: "SCREEN-SUBFORM"
(the main form has a button on it which loads the subform.)
ive tried the below code but it doesnt work, any help would be excellent.
-------------------------------------------------------
Private Sub Form_BeforeUpdate(Cancel As Integer)
If [NEW_WEEKLY_BASE] >= 0 Then
With Me.WEEKLY_BASE
.Visible = True
.Enabled = False
End With
End If
End Sub
------------------------------------------------
View 4 Replies
View Related
Dec 1, 2006
Good Afternoon to all...
I am looking to link more than one field from my subform to my main form. I have one field linked by properties (link child field/link master field). Is there a simple way to link another field from my subform to my main form?
Please Help??? Cori
View 5 Replies
View Related
Dec 4, 2013
I am creating a database for work. I have a form that has a record of information for a single contact. On that form I have a sub form that will have a series of notes that should be attached to the record that loads.
At the bottom of that form are three buttons. They move from one record to another. I want the notes subform to change when I move to another record.
How do I link the subform to the record loaded on the form.
Attached is the access database.
View 6 Replies
View Related
Aug 28, 2013
When trying to link parent to child in master and subform, I am getting a pop-up:
Subform Field Linker
"Object variable or With block variable not set"
View 3 Replies
View Related
May 8, 2014
I have two option buttons, 1_optn and 2_optn. I have two subforms, 1_frm and 2_frm.
When clicking the little round dot (the option button) for 1_optn, I want the subform 1_frm to become visible. Likewise, when clicking 2_optn, I want the subform 2_frm to become visible. In the properties panel, both forms visibility is set to No.
I have tried creating a Macro and the best I've gotten is using the OpenForm function but that opens up the forms in a new window. I'd set the Macro to the OnClick event for a combo box (as I couldn't get the option button to work) so when "1" is clicked, the form would pop up. But they have to be in the same form. No pop ups. It also has to be an option button, not a combo box or list box.It also has to be a Macro. No Event Procedure coding unfortunately.
View 1 Replies
View Related
Nov 2, 2012
I need to choose a value, which will be a number from one field (TaxRate) and have it update a field on my subform which also is a number (TaxRate)
TaxRate set subform TaxRate to value chosen
main form is named AddProducts and subform is named AddProductsSubform
View 14 Replies
View Related
May 13, 2013
I have a couple of fields in Access. To explain I will show here the fields I have and their datatype
ID: Autonummer
Amendment: Text
Basis info: Yes/No
Sex: Yes/No
Period: Yes/No
Salary:Yes/No
Shift:Yes/No
Now, in the amendment field, I've inserted a combo box, with 3 options in it. Let's say option A,B and C...The thing I want access to do, is, when option C is selected, I want fields Period, Salary and Shift to be automatically "Yes".But if option A or B is selected, the the user must choose what the other fields are going to be either Yes or No
View 8 Replies
View Related
Jun 22, 2006
I'm trying to link a form to open when a field is double clicked on the main form. When the form is opened it should open to the current record that is present on the subform.
In the opening form, I tried using a parameter query as the record source that references the current ID field on the subform. I think my problem is with referencing the value in the subform from the form that I am opening. I've read the FAQ for referencing to help me and so far this is what I've got as a parameter in the query for referencing is [Forms]![frmMainEntry].[Forms]![fsubWOArchive]![TrackingID]
The subform control on the main form is fctlWOArchive
The subform itself is fsubWOArchive
How do I get the value of the TrackingID field from a subform of another form?
Thanks,
PC
View 5 Replies
View Related
Aug 31, 2005
Hi all, i have a form with a subform, the main form has a field named: "shiftname" and i would like it so that when the form is opened the cursor is on that field but instead the cursor is on the first field of my subform. Ive tried changing the tab order on the main form (selecting form header, then shiftname) but this doesnt seem to work :( is there a bit of code i can use to force the form to open with the cursor in the "shiftname" field instead?
View 3 Replies
View Related
Oct 19, 2006
I have looked at multiple samples on this forum and others and cannot seem to get the result I want working.
Have main form TmLdr made from table of same name. Entries include ReqName and CostCenter. These same entries are on a subform. On the After Update event on the CoRecDt (main form), I want the name and CostCenter entered on the subform to populate on mainform. This subform will be filled out by the user once and as long as they are using their own machine there will be no need to re-enter their name.
I think that I am so close but just a touch away. I am attaching my DB with hopes someone can take a peak at it and let me know what I am missing. Thanks so much.
View 1 Replies
View Related
Dec 2, 2004
I have a form and a sub form. How can I create a dropdown/lookup field on the main form, which will find the customer details from the customer table, and then access the correct subform for their spend details?
I hope someone can help. Thanks in advance.
Regards
Peter
View 7 Replies
View Related
Dec 1, 2007
I have a main form with a field "Calibration Date" which shows the latest calibration date of a specific item. I have a subform that has a field "Cal Date" that is the latest calibration of this specific Item. In the Subform there may be multipul "Cal Date" enteries for that specific item but in the main form I want the "Calibration Date" to update to the newests Cal Date enetered into the subform.
View 5 Replies
View Related