displaying only current reocrds

[dominic francis]

I have a table with an start date and end date fields. I am trying to find a way to only display records on the form that are prior to the end date. any help would be great. been a long time since I have done any VB programing. please help

[CJ_London]

you would use a criteria something like this

where enddate is null or enddate>date()

[dominic francis]

Not sure what you mean

[CJ_London]

perhaps explain more clearly what you have - form recordsource for example? can enddate be null?- and what you mean by 'only display records on the form that are prior to the end date' - provide some example data and identify which records you want to include

[dominic francis]

I have DB with a list of houses to monitor. each record has a start and end date. I'm trying to have the form view only show the records where the end date has not past

[CJ_London]

Not sure what you mean

OK - so you have a form. That form has a recordsource, which for what you want will be something like

SELECT *
FROM tblHouses
WHERE enddate is null or enddate>date()

substitute table and field names for yours

[dominic francis]

I have tried and i keep getting error about cant findrecord source. could you help my form is called "residence check form" and my table is "residence check input table

[CJ_London]

looks like you have spaces in your names if that is the case, you need to surround the names with square brackets i.e

[residence check input table]