Pass data from Access subform to another form
In Access – How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

Answer Question   |  February 10, 2011  4:11 PM
Access, Access form controls, Access forms, Access Forms Database, Microsoft Access subforms

How to pick a source for a subform in Access 2003?
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]

Answer Question   |  November 29, 2010  2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms

Access Report Headers
I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport [...]

Answer Question   |  October 25, 2010  5:27 PM
Access 2003, Access reports, Header files, Microsoft Access subforms

VBA Access forms and 1 table
I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do [...]

Answer Question   |  October 18, 2010  5:44 PM
Access 2007, Microsoft Access subforms, VBA Access 2007, Visual Basic, Windows XP SP3

How can I ensure that the invoice data goes to the correct record on the subform datasheet?
I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I [...]

Answer Question   |  June 24, 2010  8:46 AM
Access Datasheet, Access forms, Microsoft Access subforms, Visual Basic Data Report

Erro in Subform in Ms Access Reports
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but [...]

Answer Question   |  November 16, 2009  7:34 AM
Access reports, Microsoft Access, Microsoft Access subforms

Master/Child Link problem in Subform
Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the [...]

Answer Question   |  October 9, 2009  11:46 PM
Microsoft Access, Microsoft Access subforms

Why won’t my Access subform stay put?
Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5″ from the top. When I click a button, it becomes visible and 0″ from the top. When I double click the button, the subform is supposed to go back to being invisible and 5″ from the [...]

Answer Question   |  August 17, 2009  4:26 PM
Microsoft Access, Microsoft Access subforms

Access – Bound sub form trying to set the value of an unbound field
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

Answer Question   |  August 6, 2009  3:44 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA

Access Subform Blank
Subform doesn’t appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

Answer Question   |  July 11, 2009  1:54 PM
Access 2003, Microsoft Access, Microsoft Access subforms

Filtering a Subform
How do I filter a form based on a value contained in the subform?

Answer Question   |  June 29, 2009  3:16 PM
Microsoft Access, Microsoft Access Filters, Microsoft Access subforms, Subform

Access Subform Repeating Data
I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn’t repeat – what do I need to do to sort this?

Answer Question   |  June 3, 2009  8:10 PM
Microsoft Access, Microsoft Access subforms

creating reports with forms/subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]

Answer Question   |  April 19, 2009  5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms

subform
I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the [...]

Answer Question   |  March 23, 2009  3:46 PM
Microsoft Access, Microsoft Access forms, Microsoft Access subforms