Record source of form referencing acontrol on another OPEN form

  • Thread starter Thread starter Spidey3721
  • Start date Start date
S

Spidey3721

Having trouble here (once again)

I am trying to get a pop-up form's ([DetailsForm]) record source to include
a
WHERE criteria that makes the form only show records associated with the
[CaseID] textbox that is showing on the main form [ServiceCallForm]

SELECT [ServiceCalls].*, [ServiceCallDetails].CaseID FROM
[ServiceCallDetails] WHERE
((([ServiceCallDetails].CaseID)=[Forms]![ServiceCallForm].[CaseID]));

I have successfully done this in the past with the rowsource of a combobox
on a popup form, where I referenced another open form in my WHERE
statement - I feel that I am doing the exact same thing (except with a
form's record source...)

I must be missing something small....

Unless this just isn't allowed with form control sources ?
 
It would help if you explained what it does (or doesn't do).

What happens if you have a saved query like that? Does it work correctly?
 
Back
Top