I have an Access ADP project (first time in my life!). There is a text field on the form, called Rdate which is a date. There is also a subform on the form, based on a view that has a date field called e_date. Link Clind Field is set to e_date and Link Master field is Rdate. It does not pull data from the view into subform. If I link on another field (character field) it works fine, but this is now that I need. Something probably does not match in SQL and Access date format. Can you please help?
Start Free Trial