Access :: Need Help With A Subform Within The Same Form

Requery Subform From Another Subform Both Connected To Main Form

Aug 8, 2014

I have a main form that has two subforms, subform1 and subform2, both connected to the main form. When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.

I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.

Me.[subform2].Form.Requery

Does not work. It errors and says it cannot recognize subform2 as a field. I have tried a field name on subform2 but I still got the same error.

View 1 Replies View Related

Forms :: Moving A Subform Within A Subform Of A Form?

Aug 19, 2015

I often move sub forms up and down within a form using something like.

Code:

forms!MyMainForm!MySubform.form.top = 500

However, I am having trouble moving a subform within a subform of a form.

Code:

Forms!MyMainForm!!MySubform!MySubformSubForm.form.top = 500

View 1 Replies View Related

Forms :: Navigation Form - BrowseTo Command To Open Up A Form In Built-in Subform Module

May 3, 2013

I'm working on the Navigation Form template in Access 2010, which is new to me. It appears that one needs to use the BrowseTo command to open up a form in the built-in subform module. I'm trying to create a couple of buttons where each button opens a form in a different data mode; one in read-only and one in add mode. Here is the syntax I used for read-only:

DoCmd.BrowseTo acBrowseToForm, "frmSales","frmNavigation.NavigationSubform", , ,acFormReadOnly

frmSales is the Sales form I want both of the buttons to open and frmNavigation is the Navigation form. It seems to be ignoring the data mode part at the end however. It only will open in Edit mode. Is there something I'm doing wrong with this command?

View 3 Replies View Related

Forms :: Design Form That Looks Very Similar To Either Split Form Or Subform

Jun 2, 2014

Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I roughly need. The form is split into two parts. In the first/top part there are some List Box/Date fields that act as filters to the bottom form, so the bottom form displays only records that match values in red. The second part of the top form has some field that require input from user and then these records are added to the bottom form. I was trying to use both Split Form and Subform and none of it is working,I have attached an example of database and this form would be based on data from Query1.

View 5 Replies View Related

Forms :: Requery Form And Subform After Popup Form Close

Aug 19, 2013

I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.

Form 1
subform 1 > button to open pop up form
subform 2
subform 3

I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.

On pop up form close, what's the correct syntax for re-querying subform 1?

View 2 Replies View Related

Forms :: Linking Form To Subform Set To Continuous Form View

Aug 22, 2014

How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?

In other words, how to auto populate the primary key to multiple records displayed the subform?

View 5 Replies View Related

Tab Style Master Form - Navigation Buttons For Each Subform Within Form

Jan 26, 2015

I have created a master form, which is a tab style. I have five additional forms that I want to use as sub-forms within each tab. I also want to include master navigation buttons that will work for each sub-form in unison. In other words if I navigate to record 10 on tab 1 and switch to tab 2, I want the new tab to show the information related to record 10. It would appear that I need to link them together in some fashion.

View 1 Replies View Related

Form,Subform,Sub-subform Help Please!!

Feb 18, 2005

I currently have a couple of problems with an input form set-up.

I have a main form (frmWebSites). On this form I have a TabBar and one of the Tab pages holds a subform (frmSiteDetails). Within this subform I have a simple option group to select between 2 further subforms that are themselves subforms on frmSiteDetails (these are frmWebSites_pgeSiteDetails_Features and frmWebSites_pgeSiteDetails_Membership). I have coded the option group to make one sub-subform visible and the other invisible and vice versa depending on what option is selected.

This procedure I call from the Click event of the option group, both the Current and Load events of the frmSiteDetails.

The controls that exist on each of the sub-subforms are bound to the same table tblWebSites as the controls on the main form (frmWebSites).

The selection between the sub-subforms works perfectly well between the 2 forms when I am on an existing record and am just viewing the data.

1. The first problem arises if I want to change the data on one of the forms.

If I change a value in any of the check boxes or combo boxes etc and then try and select the other sub-subform I get the Error message 'The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.'

I can OK this and select the option button again and the page changes as it should and the data has been updated.

2. The second problem arises with new records. If I try to enter a new record by entering details into controls on the main form everything is OK. I then try to enter further data on the currently visible sub-subform, but as soon as I then try and select the option to make this form invisible and the opposite sub-subform visible I get the following error.

'The field 'tblWebSites.SiteName' cannot contain a null value because the Required property for this field is set to true. Enter a value in this field.'

I don't understand why this is saying it is a null value as this is the first piece of data that is entered into the form. Furthermore I don't understand why it is looking at the value of this field at the time it does.

This locks me up. I can still enter data in the remaining fields of the currently visible sub-subform but not change to the other.

Any ideas where my problem lies??

Please be gentle with me, I am a complete new boy at this and this is my first Database.

Regards

Jama

View 1 Replies View Related

A Form With A Subform In A Subform

Aug 10, 2005

I do not know if this is possible but I am trying to use a subform in a subform. Meaning I have a picture(picsubform) which is in a subfrom(frmPicExample) both of these are in a form(depot tracking). The goal of this little experiment is for every record of an item it will have the ability to add, delete, next, previous etc. to allow more then one picture to be linked to one record. My problem is that I am get the following error:

(Microsoft Office Access can't find the form 'FrmPicExample' referred to in a macro expression or Visual Basic Code)

the follow is where the debug lands...

Private Sub Form_Load()

OrigHght = Forms!frmPicExample!picsubform![imgPicture].Height
OrigWdth = Forms!frmPicExample!picsubform![imgPicture].Width

End Sub

how do I add the primary form called depot_tracking?

Thank you again

roborro

View 1 Replies View Related

Forms :: Open A Form With Subform From Separate Form

Oct 23, 2014

I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error

Code:
Method 'Form' of object '_SubForm' failed.

After that, it opens (subform and all), but some calculated text fields just say "#Name?#"
The only thing I did today was add a command button to that subform.

When I try opening the form (or subform) from the navigation pane, I get

Code:
The expression On Current you entered as the event property setting produced the following error:

A problem occurred while Contracts was communicating with the OLE server or ActiveX Control

When I step through the code, it doesn't reach the On Current event.

View 5 Replies View Related

Subform Opens New Form That Gets Its Info From Main Form

Dec 20, 2011

I'm working on a project that has two tables. "Calls" and "Customers". The Customers form has a subform, "Calls Subform" in it. When you click on the (New) Hyperlink a new form opens, "Call Details". I would like to pull information off of the "Customers" Form and insert it into the newly opened "Call Details" form.

Problem #1) Home Phone (named "Phone" and Text223 (named "CID"): are both bound controls so I have to do this in an OpenArgs type process.

Further details:

On "Customers" the following is true:
"25" is the "ID" for that customer on the "customers" table
"Home Phone" is the home phone number on the "Customers" table

On Call Details the following is true:

Home Phone is Bound to a table "Calls" and needs to pull it's data from Customers Form..Text223 is CID and bound to the table "Calls" and needs to pull it's data from "Customers" form.

View 14 Replies View Related

Form/subform

Sep 4, 2006

Hi

I have used the wizard in Access to make a form and created a subform for it. I have noticed that the subform was pulled from a query; however, I think the form is pulled from the table directly.

I am not sure about the last point I mentioned above and wonder if any one knows if it's correct.

Thanks in advance.
B

View 3 Replies View Related

Form/Subform

Jul 8, 2005

Is it possible to in a form have some buttons and depending on which button you push a different subform will be displayed?

For the moment I have buttons that opens entire forms that are almost the same but with different subforms. But it feels wrong to do it this way?

-jake

View 3 Replies View Related

Form/Subform

Jan 7, 2006

I have been asked at work to take a personnel database done in File Maker and convert it to Access. For the most part its not a difficult process except for the forms.

There is a main form with all of the relevant information (date hired etc.) but I require 3 subforms that contain personal information. These are labelled
�Personal� home address, home phone, home email
�Emergency� Emergency contacts in case of accident etc.
and �Training� requests the individual has made for training and courses they have been sent on

In File Maker the subforms have tabs which you click to open or close. The �Personal� sub form (for example) opens with all of the relevant info while the main form still stays on the screen. You then click the tab again and it closes. They would like something similar to this in the Access form. Problem is, I don�t even know where to start looking.

Would some kind person point me in the right direction.

View 2 Replies View Related

Form And Subform Help

Jan 13, 2006

hi,

i am after some help on setting up a form,

let's say you hold a car event every year. (car event 2004, car event 2005, car event 2006)

your entrants could come to each of these events. I have an entrant form and would like to add a event subform with a combobox that you can select each year that the entrant is there.

is this the best way to do it, and how would i go about it.

(i have included a pic of my current entrant's form with the event sub-form but it won't allow me to use a combo box.)

View 1 Replies View Related

Form/subform, Is It Possible?

Jul 12, 2006

Hi,

I have main form with subform. Is it possible to open form on specific record, like main form ID = 2, and then add records to subform? I keep getting error (Changes were not succesful... error 3022).

For example: I would like to open form Invoce and I want it to open on Invoce number "2". Record number "2" was entered before this opening. That also mean that I get data on subform that are connected with Invoce number "2". Now the question is: Is it possible to add a new line in subform?

Thanks in advance.

View 5 Replies View Related

Form/subform

Jul 13, 2006

on my form u find a record by inputing 1 of 3 product numbers.
if a user inputs a product number for BRAND A
how can a record on my subform automatical display BRAND A company name

View 1 Replies View Related

Form And Subform

Aug 1, 2006

Hi I have 2 forms both have a field called date, what I need is when I open a form in the sub form it will appear all the records wich have the same date of the opened main form, I don't have a clue about relating the forms, can you give me detailed instructions!!
Thanx

View 5 Replies View Related

Possible To Have 2 Of The Same Subform On The Same Form?

Oct 22, 2004

Hi,

I have a database that keeps track of schedules.
A user will select a week and will have his/her schedule for the week.
I am thinking of having a tab control and having 1 tab for every day of the week.
I have created a subform which has time,location,city, person, etc. I have used a subform because on any given day there may be multiple entries of events.

If I were to do it this way I would have to have the same subform on each tab control and then try and add 1 to the date on everytab. I am unfamiliar with incremented recordsources so can someone steer me in the right direction?

Does anyone have any suggestions on if this would work? or suggestions on how I can do it differently?

My tables are as follows:

User
PK UserID
Username

Report
PK Date
PK Time
PK User ID
Location
City
blah
blah

Thank you for your help.

View 3 Replies View Related

Form/subform

Oct 31, 2004

I created a form that has a dlookup statement in an after update event procedure that populates a field based on what is entered in another field. It works great until I dragged the form onto another form to create a subform. When I change the data (using the form/subform) in the field that executes the event procedure I get an error, running the same form by itself works perfectly.

Private Sub cboservicetype_Change()
Forms!frm_Accounts!txtpayment = DLookup("[monthly_payment]", "[tbl_Support_Service_Types]", "[service_type]='" & Forms!frm_Accounts!cboservicetype & "'")
End Sub

The error I get says: Microsoft can't find the form frm_Accounts referred to in an expression or visual basic code.

Any ideas?

View 4 Replies View Related

Form/Subform

Dec 3, 2007

Hi there,

I have a form which is also build up with a subform. The form has four fields student_ID, Surname, Forename, and Numhus. The subform is build up of module and mark fields.

The problem is when I update any field on the subform (i.e., module or mark) the information is updated perfectly to the respective table, however, the Student_ID is added to the form table with empty fields in Surname, Forename, and Numhus. This in return creates a new record with Student_ID field only.

What I really want it to do is when I update the fields in the subform, it doesn't affect any other field in the main form.

N/B I have a time and date which is always updated when a field is updated in any of the subform and form. The Datemodified and Timemodified fields are in the main Form, as (hide column). This might be contributing but how to rectify it ?

Thanking you in advance

Regards

View 1 Replies View Related

Why Is Main Form Update Event Triggered When Subform Dirties Main Form?

Dec 1, 2005

I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.

BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.

In either case, the main form's Dirty event is NOT triggered.

View 2 Replies View Related

Relationship Btw Form And Subform

Jan 25, 2008

Hi,

I have a main form (stud_details) also I have a subform called (pay_det_sub).The subform is displayed on the main form.
I want to create a relationship between the stud_details and pay_det_sub, with the aid of a field on the stud_details called numhus (which is the primary key).

So that when a student with a specific numhus value is displayed it brings about the payers details on the subform.

What's the best way of doing it??? Is it necessary to have numhus value stored also in the subform table to create a relationship....

Thanks

View 3 Replies View Related

Access Subform From A Different Form.

Mar 8, 2005

I have posted about this before andhave done some reading, but cant get it working no matter what I do.

I have the following forms:

SuppierOrderCreateNew
SupplierOrderCreateNewSubForm

Obviously "SupplierOrderCreateNewSubForm" is a sub forms on "SupplierOrderCreateNew".

There is a text box on "SuppierOrderCreateNew" called "supplierOrderNumber".

There is a text box on "SuppierOrderCreateNewSubForm" called "productNumber".

I then have a second form: "ProductSuppliers". I want to return a value from "ProductSuppliers" when a button is clicked on. When the button is clicked on, I want to put the value into "productNumber". However, I dont know how to refer to the text box.

I can put the value into "supplierOrderNumber" but not into "productNumber".

Can anyone help?

I have tried:

Forms![SuppierOrderCreateNew]![SupplierOrderCreateNewSubForm].Form![productNumber] = 10

But it doesnt seem to work.

Note: 10 is not the value I want to put into the textbox, its only a random value ive been using to test the statement with.

Thanks.

View 6 Replies View Related

Relating Subform To A Form

Mar 17, 2005

I'm having a bit of a problem figuring out how to do this...

I have a form (single form) and a subform (datasheet which is based on a query which includes the data elements [via outer join] in the single form). What I'm trying to do is have the data sheet form include (view only) all records from the query and have the single form display selected fields for edit/entry (will update a table that is the outer join in the query).

Example:

Table A has "Policy Number", "Line of Coverage", and "Insured ID".
Table B has "Policy Number", "Insured ID", and "Insured Name".

Query 1:
SELECT A."Policy Number", A."Line of Coverage", A."Insured ID", B."Insured Name"
FROM "Table A" A, "Table B" B
WHERE A."Policy Number" = B."Policy Number" (+)
AND A."Insured ID" = B."Insured ID" (+)

(+) means outer join (sorry i'm used to using oracle).

So in the form I have a single form (FORM X) bound to Table B and a datasheet subform (FORM Y) bound to Query 1. I would like the user to be able to edit (or add if it doesn't exist) the "Insured Name" in FORM X based on the record currently selected in FORM Y.

Other things that may monkey with the process are the fact that even though Table B will have a unique key based on "Policy Number" and "Insured ID" Query 1 (and Table A) may have multiple "Line of Coverage" based on a single "Policy Number" and "Insured ID" combination.

Alternatively not relating the two forms, but simply populating the FORM X based on the record selected in FORM Y would be sufficient. Would this involve populating FORM X using the "on focus" function and how do I use vb to reference to a specific record in my subform?

Please let me know if I am not making any sense and thank you for your help.

-Eric :eek:

View 1 Replies View Related