I would prefer not to do a me.requery (a requery of the whole recordset). However, you would not see any NEW records that were added since you opened your form. Refresh() in that you will not change record position or see NEW records.It will update your control, assuming the control is based on a query/table. This was perfect as it did not do a complete form refresh or requery. Refresh for either the underlying recordset, or for the bound control?
I have a Microsoft Access form that is bound to a linked SQL Server table that has a computed column. I already realize that the computed field cannot be refreshed until AFTER a record is saved.
Beyond that, what is the best way to refresh that textbox that is bound to the computed column after save. Seth will refresh your Form's recordsource capturing modifications and deletions to existing records and will stay positioned on the current record.
For this i have created a Form to input the no of days present and calculate the earned salary based on the input.
Now i want to pass this earned salary value to the table field.
The fields are labelled 2010 Amount, 2012 Amount, 2013 Amount and so on. =Nz([2010 Amount]) Nz([2011 Amount]) Nz([2012 Amount]) Nz([2013 Amount])" id="ctl00_m_m_i_ctl00_gr_ctl15_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5427572" / type.
At the bottom of the display I have put a calculated field to give us the cumulative total donated by that Trust. If it is a string then it would an empty string -- "" -- which would cause problems in a sum calculation.
Can you please help me Firstly some house-keeping; With your field names it is best not to have any spaces in them, makes it much easier to code (from your SQL string it looks like you may have done this but just checking).
Also, avoid using reserved words as field names eg don't use Name as a field name, there is a list of Visual Basic reserved words here which will cover everything VBA and a little bit more.
I have a database of some 500 Trusts who have donated to our Charity.