Passing a Date Value from one Form/Table to another.

[vinsavant]

Hi!



I have a table called tbl_Main which feeds a form called frm_Main

I have added a dated field called ReplyBy to the Main table and form and would like to pass this value to another table and from. That second Table/Form is called tbl_Response and frm_Response.

Thanks!

[JoeM]

Possibly use DLOOKUP function?
See: https://www.techonthenet.com/access/...in/dlookup.php

Or create a query that links the two tables, and returns the fields that you want (you can use Queries as the Data Source of your Form just as easily as you can Tables).

[vinsavant]

Thank you for your prompt reply. If all possible I would like to add the functionality to the existing tables/forms since I have a lot of other reports already depending on them and it would take me a long time to recreate. Can you show me where /how to add this Dlookup function on a table or form?

Thanks!

[JoeM]

You would use DLOOKUP on the Form, not the Table. You should never have calculations in your Table.

If all possible I would like to add the functionality to the existing tables/forms since I have a lot of other reports already depending on them and it would take me a long time to recreate.

Actually, it is much easier than you think. You don't really have to recreate anything, just make a few minor edits.

If you create a new Query that shows all the Table fields you need from both Tables (you could easily just click * to show them all) and save it, then all you need to do is to open up your existing Form, go to Properties and change Record Source from your Table name to your Query name. Since you should still have all the same fields and field names, you shouldn't have to change any of that.

I ALWAYS base my Forms on Queries instead of Tables directly. Makes it really easy to add filters or calculations on-the-fly without having to re-do a bunch of things.