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, and I can't get the
code to work after I make the change in the query. The query will save
the changes to the form or table, 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 change more)so I would like to
keep the code on the form instead of doing the calculations in the
query and I would like to stay away from either an append or update
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, and I can't get the
code to work after I make the change in the query. The query will save
the changes to the form or table, 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 change more)so I would like to
keep the code on the form instead of doing the calculations in the
query and I would like to stay away from either an append or update
query.
TEXTBOX1 5%TEXTBOX1
Textbox2 5%Textbox2
Textbox3 5%Textbox3
Total Textbox Adjusted Textbox
Thanks in advance
Rick