Microsoft Access Subforms

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 not solution is there: NZ(), Val(),...

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 foreign key in the...

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 top. For some reason,...

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.

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.

Filtering a Subform

How do I filter a form based on a value contained in the 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?

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 when I create complete report how can...

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 command button to open the subform the...