About to give up on Tek-tips!

[Dawnit]

I know you are all so talented with Access, but I am not getting answers to my problems. Let me try one more time to describe:

I have a two tables: one to many relationship (all records from table 1, and those from table 2 where joined fields are equal)
Table 1 has [Descriptions],
Table 2 has [Descriptions], [date], [number1], and [number2]

I have one query with fields from both tables, AND expression fields:
[Descriptions]
Expr1: DLookUp("[number1]","[table2]","[Description]='" & [table1].[Description] & "'&quot]
Expr2: DLookUp("[number2]","[table2]","[Description]='" & [table1].[Description] & "'&quot
Expr3: [table2].[number1]+[number2]
Expr4: DateAdd("yyyy",([table2]![number1]+[table2]![number2]),[Date])


I have one form based on [table 1] with a [date] field

Can I use an some sort of expressiion in a new text box control source property to get a return equivalent to Expr4 above?

This is what I tried =DateAdd("yyyy",([Table2]![number1]+[table2]![number2]),[date field on form or from table 1])

I've also tried, amoung a zillion things: =[field], "query nanme"

I do not want to use VB (don't know how and have tried)

Please, pretty please help me! Or let me e-mail you a copy of my DB.

Thank you so much in advance!

 

[MichaelRed]

Oh well, since I'm not gainfully employed at he moment (Month?), I'll look at it.

At first glance, I think the references to the table fields won't work (at least as is). In general, these woould be recordset references with the recordset(s) declared and instantiated. If the Form is bound to the recordset, then you could place the fields ffrom the table (or query) which the form is bound to on the form and reference them as Fields. If you don't want the fields to be displayed, just make them hidden (e.g. visible-No n te control properties.

P.S. You ARE using VB, you are just refusing to use that name for it!



MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over