Record source of form referencing acontrol on another OPEN form

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 ?
 
D

Douglas J. Steele

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top