Stack Overflow
Stack Overflow

Questions tagged [subform]

Use this tag for questions related to a Subform, which is part of a bigger form.

394 questions
26
votes
5 answers

How to Load Form inside panel other form in win app

I Create a Windows Forms application with C#. I have a general Form and a panel on it. I show subForm into this panel with code: SubForm objForm= SubForm.InstanceForm(); this.IsMdiContainer = true; objForm.TopLevel =…
Iraj
  • 1,492
  • 5
  • 18
  • 42
11
votes
4 answers

How to get rid of adding new record at the end of a subform?

I use a subform to show the result of a query, but at the end of record there is a *(New) for adding new records. I don't want the user to be able to add new records through this subform. How can I get rid of this?
Jarong Hsu
  • 125
  • 1
  • 2
  • 5
8
votes
2 answers

Setting Filter in Subform

I've a main form "Properties", which has two subforms, one of which displays the rooms in that property, the other one occupants in each room. As you change the property, the rooms change in the first subform, which is continuous. As you scroll…
7thGalaxy
  • 225
  • 1
  • 2
  • 8
7
votes
3 answers

Access sub form not loaded when using SQL tables

I have a form in access with 5 nearly identical sub form . When I load the form it usually go fine. However, we recently changed from Access backend to SQL and since then , the form doesn't seem to load properly. If I go to design mode and then to…
David Brunelle
  • 6,528
  • 11
  • 64
  • 104
6
votes
1 answer

Add a subform to a form with ajax on submit

I read this article: http://www.jeremykendall.net/2009/01/19/dynamically-adding-elements-to-zend-form/ That was very interesting and it works fine. I need to do the same but with a SubForm. I mean that when a user presses a button, I call, via ajax,…
Samuele
  • 512
  • 1
  • 9
  • 23
6
votes
2 answers

Subform values are showing up as null on the receiving end after form submit

I have built out a form which submits fine, however subform values all end up as null on the receiving end when I look at them in the controller. Here is my UserProfileType form, based on the Userclass. So specifically, the subforms we are looking…
Brent Heigold
  • 1,213
  • 5
  • 24
  • 50
5
votes
2 answers

How to reference a subform in MS Access

In my MS Access application, I am using a form which contains only two controls - a textbox and a command button. This form is named as HEADER FORM. HEADER FORM is used as a subform in header section of various other forms. What I want to do is…
Jay
  • 1,210
  • 9
  • 28
  • 48
4
votes
3 answers

Requery subform from another subform, problems

I have 2 subforms on the main form. Sub_2 displays the details for the item chosen in sub_1, in a list. For both subform, I use the continue form, and they are bounded to 2 querys, with one field in common, say 'id'. What I have done is adding code…
darkjh
  • 2,821
  • 7
  • 35
  • 43
4
votes
2 answers

using ColumnHidden properties within Datasheet objects

I have a MS Access form with a Datasheet subform. Using code, I change the ColumnHidden property of various of its columns. But, when I close the form, I'm asked whether to save the table layout of the Datasheet's table. How can I stop the form…
lamcro
  • 6,069
  • 18
  • 57
  • 70
4
votes
2 answers

populate a many-to-many table with access

I have two tables (persons and projects) which are in a many-to-many table, thus linked together by a third table persons_projects In ms access I now created a form showing data from the projects table. What I want is to have a subform showing all…
knittl
  • 246,190
  • 53
  • 318
  • 364
3
votes
2 answers

Show records based on same id in three subforms in Access within a form

I know I'm looking for a quick fix and that the main issue is in the database design but for the moment I cannot do anything about it. So here's my wish: I have three tables TableA, TableB, TableC all sharing ID as key with referential integrity…
Jan
  • 3,825
  • 3
  • 31
  • 51
3
votes
3 answers

Ahhhhh! Where did the subform go?

I have a form called Group in my MS Access ADP. On it is a tab control, and in each of the tabs there is a subform. The first tab contains the subform Users, and it isn't showing up in form view. Subform Users shows up in design view. Any clue as to…
dmr
  • 21,811
  • 37
  • 100
  • 138
3
votes
1 answer

Selecting a record in Access Subform

I have a form in Access 2003 that contains 2 subforms. The first is in datasheet view and is only 2 fields, SiteID and SiteName, so a list of many sites for one record in the parent form. The second subform is the same datasource as the first, but…
Glenn M
  • 455
  • 2
  • 8
  • 16
3
votes
1 answer

Use Access VBA to change the record source for a form

I am creating a search form and I am unable to see the search results in the subform. The query runs fine, I have set the subforms record source to the query. I donot get any errors. When I click the search button the query runs and it shows the…
ksagar
  • 305
  • 3
  • 6
  • 20
3
votes
1 answer

Does Django Admin Site have Subform?

Say there're two tables: table: Company field: ID, Company_Name table: People field: ID, People_Name, Company_ID I used to use MS Access, create a people form, a company form, then bind people form into company form as a "Subform". Now I am learning…
hlpmee
  • 63
  • 4
1
2 3
…
26 27