Hi, I am having problems finding a way to look up a record in a external database, Access 2007, and using the query data to populate fields in a list's NewForm, How do I get the values from a SQLDataSouce to pass through to parameters?
I'll Revise as ask.
I need to do a simple lookup of a table in an Access 2007 database, using user input from a sharepoint site. The user would enter a UID and click a submit button. A query would create a connect to the database from Sharepoint, and query the table for a record. Once a record is found in the database, I need to created a new record (item) in a list in my sharepoint site, useing the information from the recordset, but I want to give the users a way to edit the data before saving the item to the list. My problem at this point is I can not get the entered UID value passed to the query, nor can I get record passed to the SP Form. If I hard code the UID into the query, I get a record, but then I can not populate the form with the information.
Has anyone done something like this that could advise me as to what I need to do to pass the record information into the list's newform.aspx
(yes I did create a custom form, and can pass information to the fields from another list.)