Search results

Lets say the field you are updating is called 'fld_number' and that the field you want to change when fld_number is updated is 'fld_quantity' - and that this field is on the same form. Then you would use the following code: Private Sub fld_number_AfterUpdate() fld_quantity.Value =...

My suggestion would be to set up another table with all the 'yes' options listed, then, in on the form you can create a combo box based on the 'yes options' table. Make sure you have a field in the original table that you can save their selection back to eg "yes_option_picked"

Hi, The way i have done that in my databases is as follows: On the original form: When i select an item from my combo box it populates (using an after update event) a label with the ID that i have created which is not visible in form view, using the following code: Private Sub...

Hi Brian, I have struggled with the same thing & came to the conclusion that a data access page is for "accessing" the data only - not for updating/editing it. I hope that I am wrong & someone else can help out. :) Dione

Hi, Don't know if this will help but: Can you have a form with an option group And then base the query on the form for example in the query have something like (in the SQL): ORDER BY IIf(Forms!frm_08_reportsort!opt_sort_by=1,field1,field2), what the above will do is sort by field one if you...

Thanks for your help guys - with ur advice i have got it sorted :) sorry for delayed reply - had to work on other stuff for rest of week

Hi all, My problem is as follows: I am trying to generate a report, which is based on a query, which references a form that has an option group containing four options. I want to sort the data according which option group radio button has been selected (they the values of 1,2,3,4)...