subform

I have a tab view on my form with a subform on top (not within the tab). My tabs are dates. I want to set the parent as the date on the tab and the child as the date on the subform on top. Can I do this through the property sheet or do I need VBA to do it?

I am designing a data entry form with a subform. In the subform, I have a list box control that has an inherit value list from a lookup table. On the main form I have a combo list that I am using as a record selector that filters the record on the subform. How can I filter the list box with...

Hi. I would really appreciate your help on this issue. I have two subforms on the same form. On the left side I have a list of authors, and on the right I have the books they have written. I would like to select an author and automatically filter the list of their books, as shown here (I...

Good Afternoon, I am trying to create a subform that pulls data from a query that uses fields in the main form as its criteria. Everything works fine if I use 5 criteria fields but I need to use 7 and as soon as add the sixth and try to run I get the error mentioned in the title of this...

I have a database with the main form titled "Orders" and a subform titled "Orders Subform". They are related through the OrderID on both forms. However, every time I add a new record to the subform it creates a new main form. I don't need 10 duplicate orders because someone ordered 10 items...

Hi, I am trying to get a subform to show the results from a query, the code below loads the form sets the recordset which i know works as the subform lets you scroll through 4000 odd records BUT none of the records are actually displayed, :mad: any ideas why this may be or how to fix it...

I'm tring to toggle the visible property of a column in a sub form based on input from a check box on the main unbound form If Me.Check55 = True Then 'This part works fine, if checkbox 55 is true the subform filters records based on "DBSUB.[Austin] Yes or No strWhere = strWhere & " AND " &...

Hello! I have a form (called, let's say, MyFormName) that has 3 combo boxes on it. The user selects a value from a list in the first combo box, and then I use this code - <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Me.SecondComboBox.Requery...

Hi, my supervisor has given me a task in access... Im not really familiar with access, and i need to get it done by the end of the day. I have a form for a project. It has information fields for project ID;title ; short desccription; project start and end date.. but the problem is, it doesnt...

I need help with form/subform lost recognition. I am not sure what happened but my subform is no longer recognized on my form. This may have happened afte a record (in sub form) was deleted. My information on this is not clear, however here it iswhatI have. The outline of the subform is there...

I need some help in subform references in formulas, ie, I have Main form: frmMain subform sfrmSub1 sfrmSub1 fields: cost1, cost2, iCnt sfrmSub1 will have more than 1 record For instance, how do I do calculations such as cost1 * iCnt, cos2 * iCnt etc. Also, how do I differentiate between...

I am trying create a form that has the main form as medbill containing vendor name, account number etc. I also have a subform medbilldetail that has invoice number, description, etc. There are two tables, medbill & medbilldetail; medbilldetail has a field medbillID, numeric long integer. The...

On my form I have a list box containing manager names. Below that list box is a subform. This subform shows the multiple store associated with that manager, multiple programs associated with each store, a percentage for each program, and a yes/no column. The form is used to add and delete...