Assign default value, allow user to overwrite and update query

[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?}

How do I go about setting this up?

 

[tina]

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.

you can't "store" or "update" data in a query. queries don't hold or store
data; tables do. can you explain a little more clearly what you're trying to
accomplish? such as, "my form is bound to table such-and-such. it has a
(bound? unbound?) textbox. i retrieve a value (from a DLookup() function?)
to use as the default value. if the user changes the default, what i want to
happen is..."
if we can understand better what you're trying to do, probably we can help
you figure out a way to do it.

hth

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?}

How do I go about setting this up?

 

[Guest]

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.

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.

you can't "store" or "update" data in a query. queries don't hold or store
data; tables do. can you explain a little more clearly what you're trying to
accomplish? such as, "my form is bound to table such-and-such. it has a
(bound? unbound?) textbox. i retrieve a value (from a DLookup() function?)
to use as the default value. if the user changes the default, what i want to
happen is..."
if we can understand better what you're trying to do, probably we can help
you figure out a way to do it.

hth

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?}

How do I go about setting this up?

 

[Guest]

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!

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.

you can't "store" or "update" data in a query. queries don't hold or store
data; tables do. can you explain a little more clearly what you're trying to
accomplish? such as, "my form is bound to table such-and-such. it has a
(bound? unbound?) textbox. i retrieve a value (from a DLookup() function?)
to use as the default value. if the user changes the default, what i want to
happen is..."
if we can understand better what you're trying to do, probably we can help
you figure out a way to do it.

hth

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?}

How do I go about setting this up?

 

[tina]

well, i'm afraid you've stumped me; perhaps somebody else will be able to
offer a solution. good luck.

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.

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.

you can't "store" or "update" data in a query. queries don't hold or store
data; tables do. can you explain a little more clearly what you're trying to
accomplish? such as, "my form is bound to table such-and-such. it has a
(bound? unbound?) textbox. i retrieve a value (from a DLookup() function?)
to use as the default value. if the user changes the default, what i want to
happen is..."
if we can understand better what you're trying to do, probably we can help
you figure out a way to do it.

hth

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?}

How do I go about setting this up?