Link to home
Start Free TrialLog in
Avatar of subathira
subathira

asked on

Date field in MS access stLinkCriteria

Hi,
   In my MS access 2000 application i have a form 1. There are three fields on form 1 as Start date  end date  and Status.If status value is selected all records between the start date and end date for the corresponding status to be retrived and displayed in Form 2. If no status is selected then all the records for the date range to be displayed.
How to achieve this using stLinkCriteria. I was able to open the Form 2 for the date range. Can some one can give me the syntax of passing the text values to check the date field in stLinkCriteria.
Thanks,
suba
ASKER CERTIFIED SOLUTION
Avatar of Shane Russell
Shane Russell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the asker requires more help and replies here to let us know I will try and help them as much as I possibly can :) but thanks for the accept :)