I am not sure if this classifies as a form problem or a module problem. I am pulling a recordset based on the users input from a combobox (i.e. "Select a donor to update", then when they select the record, I populate the text boxes with the recordset information). Yet I cannot figure out a way to pass the recordset to the command button so I can update the record with the new information(i.e. onclick rs.update). Access will not allow ByVal passes in command_clicks. I am struggling with this, I hope someone can pleaeeeaase help.

Thanks in advance.

Matt Ward

You populate the fields of the recordset with the fields from the form:

Rs!YourField1 = Me.YourField1
Rs!YourField2 = Me.YourField2
etc.