Recent content by maxcess

I can see your point of view, but I believe waiting 12 hours for a reply on one site before posting to another site is a legitimate request for help from more sources.

I have an Orders form, without any underlying related tables. Located in the upper half of this form, I have a sfrmOrders in datasheet view with a ssfrmOrderDetails as a subform embedded in it. On the lower half of the form, I have a sfrmOrderProcessing in single form view. The goal is for...

Please help. I'm trying to use code in the On Current event of a form where a field name DIDA is examined for a 0 value. If it is found, the value of the DIDA field would match the value of the previous autonumered DID field. The default value of DIDA can be set at 0 in the table properties...

Oop, spoke too soon on the drop list part... looks promising.

Adam, that was intelligible enough. You understand the concept, and the outline.zip was awesome. Because it is a datasheet, however, drop lists and autocomplete are not available, and not much is possible for dressing up the appearance. I have a better grasp of the overall design limits now...

Thought so. Subform will need to be in footer then. This is where I get the Parameter error that I posted separately now.....

Indeed it does. But I am looking for interleaving the child form values with the parent form. Like one can do in a report.... Heading1 value1 value2 value3 value4 Heading2 valueA valueX value6 Heading3 valueZ value3... as opposed to: Heading1 Heading2 Heading3...

It does not appear harmful, just cosmetic. Is there a way to supress it or deal with it. The issue seems like http://support.microsoft.com/default.aspx?scid=kb;EN-US;811860 but it is Windows 2000 with Access XP rather than Windows XP. The condition follows when the main form closes. There is a...

Looks like a bug in Access at the third subform. As long as the editing is done with form and subform, the link build button works correctly.

The master and child are set, but it still looks like master table above and child table below, not interleaved.

Tried the subform in the form footer, but the values did not appear to insert themselves between the parent data rows. One was stacked on top of the other. Is that what is to be expected, or were my settings possibly incorrect. The button idea is a possibility - just trying to avoid mouse clicks.

Is it possible to make a form look like a continuous cascading outline (kind of like a report can list things under a heading using page header/footer criteria). That suggests a continuous form within a continuous form where the second form can expand and contract between the rows of the main...

Not sure how the error started happening. Creating a new form with subforms worked without error, until at some point, the master/child link box returned this error. From what I have researched on this error so far, the underlying table properties are correct (required vs not required). There is...

Righto. That worked, and for a subform the expression was Forms![frmStaff]![sfrmStaffList]![chkInactive]=True. Thanks...

Is it possible to use If..Then to change control colors on a continuous form? It works for a single form, but using a checkbox for a value to color other controls sets all controls in a continuous form the same. Example: If Me.chkInactive.Value = True Then Me.Firstname.ForeColor = vbRed...