none
Macros/Forms Problem RRS feed

  • Question

  • We have a form that allows the user to click on a customer code, which then leads to another form where the user can view past projects by that customer. All of this works, but then when the user clicks "Add new project," we can not get any of the information from the previous form to display on the screen. In each box (Such as the project number box and customer code box), the error message "#Name?" appears. We have tried numerous ways of changing the macros, but none of them seem to work. We really just want the information on the previous form to reappear as well as give the user the opportunity to add a new project number. Any help is appreciated. 
    Wednesday, December 30, 2015 7:04 PM

All replies

  • Hi. It all depends on how you have set up the form. Is it a bound form? Is there a one-to-many relationship between customer and projects? If so, I would recommend trying to use a form/subform setup. What does the code for the "Add new project" button looks like?
    Wednesday, December 30, 2015 9:15 PM
  • >>> In each box (Such as the project number box and customer code box), the error message "#Name?" appears. We have tried numerous ways of changing the macros, but none of them seem to work. We really just want the information on the previous form to reappear as well as give the user the opportunity to add a new project number. Any help is appreciated. <<<

    According to your description, the #Name error usually occurs because you have used a name for a field that is not in the Form's Record Source & Field List or is not one of the unbound text fields added later. So I suggest that you could add a default value to form control whenever you want Access to enter a value in a new record automatically.

    Thursday, January 28, 2016 9:26 AM