forms to table question

[aperture]

hello all

i have a quick question. i have a form that is linked to a table, and unless the user highlights the values they enter in required fields (text or list boxes), the values do not show up in the table. how can i eliminate this requirement?

thanks,

ap

 

[genomon]

Assuming the form has a command button (cmdUpdate, etc), in the OnClick event:
Open the table as a recordset in VBA (form's HasModule property = true). Use .Edit, then set fieldnames = control (text box) values, then use .Update. Might need to do a .Refresh before you see the changes in the table (can't remember).