Current record and a query

[3Mark3]

Good morning everyone,
I have a question regarding the "current record" and a query I have.

I'm trying to do an append query based on a few fields in a form. I have two fields in the append query that look at the values entered in two of my subforms in my main form. The criteria in those two fields in the update query look like this:

loan looks like:
[Forms]![rpt_74_subform]![loan]

The Exception type looks like this:
[Forms]![audit_findings_assign]![exception_type]


How can I get the loan field to look at the current record that is selected in the subform in my main form? It's odd because I know I've created such a query several times. Thanks in advance!!!

 

[lynchg]

Look in Access Help for the correct syntax when referring to a control on a subform. I remember it is a little odd and it's been a long time since I have done that so I don't recall exactly what it is.

Once you refer to the subform correctly your code will pick up your selections.

Good Luck.

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

[Forms]![main form]![rpt_74_subform].Form![loan]
[Forms]![main form]![audit_findings_assign].Form![exception_type]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886