R
Rick
I have a form in which I want to make quick changes to certain fields
on different records so I made a select query to view and edit the
fields of choice from a command button on the form.
I have basic code on the form to add or do numerical calculations to
the values of those different fields of choice, I can't get the code
to work after I make the changes in the query. The query will save the
changes to the form, but the code will not work.
If I manually go through the steps of change on the form the code
will work fine using the AfterUpdate event. I have tried putting the
code on the load, focus etc. event of the form but the form goes into
a data entry mode and will not accept the changes from the query as if
two people are inputting data.
The changes that are made in the query are usually to one or two
textboxes at a time with options to make more so I would like to keep
the code on the form instead of doing the calculations in the query.
Textbox1 5%Textbox1
Textbox2 5%Textbox2
Textbox3 5%Textbox3
Total Textbox Adjusted Textbox
Thanks in advance
Rick
on different records so I made a select query to view and edit the
fields of choice from a command button on the form.
I have basic code on the form to add or do numerical calculations to
the values of those different fields of choice, I can't get the code
to work after I make the changes in the query. The query will save the
changes to the form, but the code will not work.
If I manually go through the steps of change on the form the code
will work fine using the AfterUpdate event. I have tried putting the
code on the load, focus etc. event of the form but the form goes into
a data entry mode and will not accept the changes from the query as if
two people are inputting data.
The changes that are made in the query are usually to one or two
textboxes at a time with options to make more so I would like to keep
the code on the form instead of doing the calculations in the query.
Textbox1 5%Textbox1
Textbox2 5%Textbox2
Textbox3 5%Textbox3
Total Textbox Adjusted Textbox
Thanks in advance
Rick