Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form - Data access page problem

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
My problem:
I have 2 different databases. 1 is displayed as a Form and the other 1 as a Data Access Page (dap).
I would like to, if possible, send parameters from a textfield (holds information from a table) in the Form, to a textfield in the dap-page.

Some thing that I´ve tried is to export the source-table from the Form to the dap-page and try to access the information but failed.
I´ve also tried to create a macro which exports the information in the table to the dap-page but also falied.
 
Something you might want to try.
Use the docmd.openform method and the last parameter is OpenArgs. You can pass you info through this parameter and place code in the dap load function if there is one. I have never tried this on a dap but it works well with forms.
The code in the load method of the dap should look something like this,

if not isnull(me.openargs) THEN
textfieldname.value = me.openargs
else
<whatever other code you have>
endif

I hope this helps.
Brian Coats
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top