Getting data from a subform

  • Thread starter Thread starter HeatherD25
  • Start date Start date
H

HeatherD25

Hi,

I have a log-on screen where a user enters their username and I capture
their CONTACT_ID value. When they log-on, I want another form to open that
only shows their assigned projects they need to work. There are 4 different
types of projects -- 2 are assigned on a main form and the other 2 are
assigned on the subform. I have figured out how to do the filter to only
display their assigned projects from the values on the main form, but I can't
figure out how to do it on the sub-form.

Here's what I have for the ones on the main form. This is working:

Criteria1 = "(([REFERRED_TO]=" & Me.[CONTACT_ID].Value & " OR " &
"([INTERNAL_REVIEWER]=" & Me.CONTACT_ID.Value &

How do I capture the other two values?

Thanks,
Heather
 
Hi Heather

I would use a Query as your recordsource instead of a filter. Are you using
User Level Security? If so, you can use CurentUser() to determine the person
who is logged on, so your query would contain that as the criteria.

hth

Niko
 
Back
Top