Bind text boxes to data in different records on one form

[sbaptista]

What is the most efficient way to bind text fields on a form to data from different records and then be able to update all records with one button? For example, I have a form whose Record Source is a query that returns the following records:

ID	Param	ParamVal
1	DropFolder	c:\drops
2	LogFolder	c:\logs

I would like to do the following:

1. Create text field-1 that binds to record #1 ParamVal ("c:\drops")
2. Create text field-2 that binds to record #2 ParamVal ("C:\logs")
3. Allow the user to modify the contents of the text fields
4. Update all with a button

Thanks


-Stan

[June7]

Maybe possible with side-by-side subforms, each filtered to the desired record.

Entry/edit of data is committed to table when: 1. form closes, 2. form loses focus by clicking elsewhere, 3. move to another record, 4. run save code

[sbaptista]

Thanks a lot. I decided to handle the database updates in VBA. I'm using one form that updates multiple records based on which control is modified by the user.