Edit Data in Recordset

[Bwilliamson]

I need some guidence on updating some data in a recordset.

Basically what I am trying to do is have the user enter an amount in the PhyPctComp field ( which is a raw field from a table, no calcualtions) and have the fields after it in the query recalculate the totals in them based from the amount entered by the user. They have requested this be in a datasheet view, not a regular form view.

So say the user inputs a percent complete of 50%, it will then take the totals from other fields and recalulate $ and hours based from how much of the job is complete.

I can't figure out how to get this to happen. Also I'm having trouble making the Percent complete field editable when it is bound. If I make the field unbound it changes the values for every entry.



Just can't seem to slove this and I would appreciate some direction.

[RuralGuy]

Maybe this link will help with part of your problem: http://allenbrowne.com/ser-61.html

[Bwilliamson]

Maybe this link will help with part of your problem: http://allenbrowne.com/ser-61.html

I appreciate the help. The issue was due to the form having a control source of a query. I worked around it by creating a temp table, then clearing it and requerying it at the On open event.

 
Private Sub Form_Load()
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_Delete_working", Datasheet, Edit
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_Forecast_Master_Lab", Datasheet, Edit
DoCmd.Requery "frmWorking_Lab"

[RuralGuy]

Glad to hear you got it sorted. You do know that it was *not* because the RecordSource was a query but that the query had ambiguous records, right? I use queries with joins all the time that are updateable.