G
Guest
Still need help!!
Plese see "Assign default value, allow user to overwrite" for more details
Plese see "Assign default value, allow user to overwrite" for more details
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Please post your question. We do not know where to go looking for it.
G
Guest
I wish to assign a default value to a text box and allow the user to
overwrite it. The default value is taken from a query field. I have a
continuous form and I want the user to be able to change only one field.
Then the total should be automatically updated.
Basically, I want the user to edit the information and then update the total
in the query. If the user makes changes, store/update the amount in the
query, else keep the default value set in the query. I thought I could do
something like this in the afterupdate event:
Me![txtApproved] = {what the user entered?}
It is a little bit complicated, but here we go. "Table1" is used in query
"Query1" with the column 'Amount' as the important one. "Query1" is a
complicated query that is based on several other queries, based on the same
table. The only reason for this complication is because of some criterias I
need. Basically I end up with two queries that I union together in "Query1".
These two queries do exactly the same, but with different criterias. It has
three columns added/"calculated" where the last two are the same as 'Amount',
but are 0 or the amount based a criteria from one of the fields. Also, these
two queries have criterias from listbox and comboboxes. The form I use is
linked to "Query1" and I put the values to bound. However, the field I want
to be able to edit called 'Approved' was set to unbound and then default =
'Approved'. I was able to change the values, but it changed the values of
all the fields instead of only that field. The reason I wanted to keep the
changes made by the user is because I wanted this to be used in another form
to calculate the total of part of these numbers. Basically, there is about
18 records in this forms that the user will need to check all the individual
fields in each record for and make the changes he/she wants. The totals in
each 18 records will then be used in another form that contains 3 records
(continuous form). However, I am exporting this form to excel and might be
able to have the user manually make the changes, total it, and then import it
back to the database. But this seems to be more complicated. I want to have
everything automated for simplicity.
If possible, I can have the user edit the amount in 'Approved', recalculate
the total, and save the value in the total. I am basically just going to use
the total amount in the further calculations. Hope this helps in making it
work!
overwrite it. The default value is taken from a query field. I have a
continuous form and I want the user to be able to change only one field.
Then the total should be automatically updated.
Basically, I want the user to edit the information and then update the total
in the query. If the user makes changes, store/update the amount in the
query, else keep the default value set in the query. I thought I could do
something like this in the afterupdate event:
Me![txtApproved] = {what the user entered?}
It is a little bit complicated, but here we go. "Table1" is used in query
"Query1" with the column 'Amount' as the important one. "Query1" is a
complicated query that is based on several other queries, based on the same
table. The only reason for this complication is because of some criterias I
need. Basically I end up with two queries that I union together in "Query1".
These two queries do exactly the same, but with different criterias. It has
three columns added/"calculated" where the last two are the same as 'Amount',
but are 0 or the amount based a criteria from one of the fields. Also, these
two queries have criterias from listbox and comboboxes. The form I use is
linked to "Query1" and I put the values to bound. However, the field I want
to be able to edit called 'Approved' was set to unbound and then default =
'Approved'. I was able to change the values, but it changed the values of
all the fields instead of only that field. The reason I wanted to keep the
changes made by the user is because I wanted this to be used in another form
to calculate the total of part of these numbers. Basically, there is about
18 records in this forms that the user will need to check all the individual
fields in each record for and make the changes he/she wants. The totals in
each 18 records will then be used in another form that contains 3 records
(continuous form). However, I am exporting this form to excel and might be
able to have the user manually make the changes, total it, and then import it
back to the database. But this seems to be more complicated. I want to have
everything automated for simplicity.
If possible, I can have the user edit the amount in 'Approved', recalculate
the total, and save the value in the total. I am basically just going to use
the total amount in the further calculations. Hope this helps in making it
work!