Search results

  1. G

    Declaring workspace in one form causes other form to lose track of its recordset?

    I'm been struggling with a mysterious problem for days now and I finally found the cause. Now I wonder if anyone knows how to fix it... Here's the problem: I open frmCashAccounts, which is bound to a query that draws from tblAccounts. The form has a standard "Go to record" combo box with...
  2. G

    using a locked combo box to change data

    Hi Access experts, I have a subform in datasheet view that has a bound combo box that's based on an expression and can't be updated, but I'd like to let the user edit it. Impossible, right? But the user can still click the dropdown and see the list of options and then click on an option. Of...
  3. G

    prevent undo in form datasheet

    I have a "txtAmount" textbox with an AfterUpdate event that runs an update query on another record based on the new value of txtAmount. I need to be sure that the user can never change the value in txtAmount without this update query firing. But if the user changes the amount, saves the record...
  4. G

    Continuous form with unbound combo drilldown, conditionally hidden controls, and more

    I spent all day working on this yesterday and I think I've got a pretty good solution. So I wanted to share my findings with others in case it might help anyone else. I was also hoping that people might offer suggestions on how to improve on what I've got or ideas of other possible solutions...
Top Bottom