Filter Date in Subform based on Date Picker in Main form

[Elwood07]

I'm going nuts here:



I have a main form "SCParent" and 1 subform "SCSub"
The main form has a combo box for outlets. User chooses the outlet name from the box and the subform displays all records from that outlet. Parent and Child is linked through the Outlet ID#. This part is working just fine.

User needs to then choose a date on the main form using a date picker in a regular text box (which is set to default value today). I need the subform to display records from that outlet from that the date chosen.

The date picker is labeled txtDateFilter and the date field in the subform is labeled txtTicketDate.
I can't for the life of me figure this out, and think it should be pretty simple.

The main table combo box pulls from "Outlet" table and the subform pulls from 3 different tables, all linked with working relationships. The txtTicketDate pulls from table "Ticket".

Thanks in advance for your help!

[CJ_London]

try modifying your subform linkchild and linkmaster properties to include the date - i.e.

child - [Outlet ID#], TicketDate
master - [Outlet ID#], txtTicketDate

[Elwood07]

try modifying your subform linkchild and linkmaster properties to include the date - i.e.

child - [Outlet ID#], TicketDate
master - [Outlet ID#], txtTicketDate

Hi Thanks for responding, but the text box on the parent isn't linked to any field in the database. I tried what you said, but the drop down for the master doesn't have the date box listed; only the fields that are part of the Outlets table so i don't have a way of linking.

Thanks

[ItsMe]

If the textbox is unbound, you could apply the value of the unbound textbox to the subform's Filter property. Just be careful that the user does not accidently change the filteron property to = No. An alternative may be to affect change to the subform's RecordSource.

[Elwood07]

Thanks - I have no idea how to do what you're suggesting.
I don't know how to set the filter property.

[orange]

You could try google
"MSAccess setting a filter on a form youtube"
https://www.google.ca/search?q=MSacc...BMamyAS01onYBQ

[CJ_London]

but the text box on the parent isn't linked to any field in the database.

Rather than using the dropdown options, just type it into the properties

[ItsMe]

Rather than using the dropdown options, just type it into the properties

Hmmm, never tried that one.

[Elwood07]

Rather than using the dropdown options, just type it into the properties

Tried that...i typed in txtDateFilter for the master link and I still get a pop up parameter box to enter in the date, like it's not reading the date I just chose in the box. The date box gives me the NAME error; the ticket date on the subform does filter, though, so it's a step in the right direction, but not quite right. Thanks.

I started with google searches; I just don't know Access well enough to understand the jargon.

[CJ_London]

c...i typed in txtDateFilter for the master link

previously you called it txtTicketDate

[Elwood07]

the text box in the master with the date picker that the user chooses is txtDateFilter and the field in the subform that needs to filter by that date is txtTicketDate.
I put txtDateFilter in the Master link and txtTicketDate in the child link.

[CJ_London]

Sorry - missed that

txtTicketDate in the child link

are you really prequelling your field names with txt? or is this the name of the control? It needs to be the name of your field

However also forgot that when using an unbound control for the master link, you need a bit of code in the current event or that controls after update event to requery the subform to update it, so since you need code, you might as well go the filter route