InfoPath Dev

Hi guys,

I have a form that is attached to database on the backend.  We are trying to make an more efficient way for the user to update a task by her pulling it up in a query and puttiing in the bulk date.  What I need is the next time the form is opened for that date to pull into that field on the form.  Is there a way to make this happen?

Ok, I guess this needs more information now that I go back and read it.  The user is updating 6 dates, she updates many customers at one time so we built a query in the database and she is updating that "spreadsheet" view in the database.  However, I need that information to feed back to the form once she has made her updates.  I have tried just putting the query parameter on the data fields and it isn't working.  I have another field that is an autonumber field from the database and it updates on first submission but these fields just will not update.

However, the database has 25 tables, these fields are in one of the cascading tables, if I update one of those fields then it will update those fields on submit.  I really need these to update on Open, is there anyway to do that?

Any ideas?