Hi All,

I use a form with a subform.
When I set a filter to show only records from a certain date I change
the source to this:

strSource = "SELECT Tabel_Aanvragen.*, VISA.* " & _
"FROM Tabel_Aanvragen RIGHT JOIN VISA ON Tabel_Aanvragen.ID =
VISA.ID"

If Not IsNull(Me.txtStartDate) Then
strWhere = strWhere & "([VISA].[datum_aanvraag] >= " &
Format(Me.txtStartDate, conJetDate) & ") AND "
End If

If Not IsNull(Me.txtEndDate) Then 'Less than the next day.
strWhere = strWhere & "([VISA].[datum_aanvraag] < " &
Format(Me.txtEndDate + 1, conJetDate) & ") AND "
End If

Form_subFrmTabelTotaal.RecordSource = strSource
Form_subFrmTabelTotaal.Filter = strWhere
Form_subFrmTabelTotaal.FilterOn = True

The database shows me the records correctly, but when I doubleclick to
open one of the records in a seperate
form it will give me an error message:

2424
The expression you entered has a field,control or property name that
VisaAanvraag can't find.

Why can I open a record in subform when I show all records but not
when I set a filter?

Regards
Marco
The Netherlands

Co wrote:
I don't know. Why are you resetting the subform's recordsource?
strF = "[SubFormDateField] > #" & Me.SomeDate & "#"
Forms!MainFormName!SubformName.Form.Filter = strF
Forms!MainFormName!SubformName.Form.FilterOn = (strF > "")
should be all you need (as an example).

On 28 sep, 18:17, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
That's because initially I just call the table called Tabel_Aanvragen.
This table holds personnel records.
When I want to see all the VISA application from one person I call
this JOIN:
SELECT Tabel_Aanvragen.*, VISA.* " & _
"FROM Tabel_Aanvragen RIGHT JOIN VISA ON Tabel_Aanvragen.ID =
VISA.ID"

Marco