Recent content by Andreww1986

  1. A

    Button on From prefill field on different form

    That is how I have it setup now. What I am looking to do is have the Changes form have fields auto populated like Application Name and Ticket Number so the user does not have to input these into the form every time there is an update.
  2. A

    Button on From prefill field on different form

    What I would like to do is create another table and form that is for updating an ongoing incident. So you would first go to the application click the button we just created, which take you to the incident form and populates the application name. You would then fill out the remaining fields on...
  3. A

    Button on From prefill field on different form

    That did it! Thanks!! If i wanted to have a similar button add 2 fields to a new form say Application Name and Incident number would i used the above code and just add a second openArgs?
  4. A

    Button on From prefill field on different form

    I have attached the db with some test information. If you notice when you go to the application list and click new incident it will populate the correct name but also prefill the rest of the fields with an incident that has been logged in the incident library table.
  5. A

    Button on From prefill field on different form

    I have noticed during testing if i have a record saved in the Incident Information field. Then go to a different application and click the button it is pulling over the correct application name but also the information that was entered previously for an application. Is there a way to make sure...
  6. A

    Button on From prefill field on different form

    Thanks for all your help really appreciate it!
  7. A

    Button on From prefill field on different form

    I got it finally!!!!!!!!!! I had to delete and recreate the button and now it is working perfectly! Thank you for your help. Not to hijack my own thread but i do have a follow up question. you will see in the test database I provided you will see my application list form has to fields number...
  8. A

    Button on From prefill field on different form

    I notice when I start to type Application on my new database it would populate and i could select Application_Name on my original it is not doing this.
  9. A

    Button on From prefill field on different form

    Ok, So I created a dummy database and copied what you have above and it is working now!?!?! My questions is since I have changed the names of the fields within my actual Database is this causing confusion when trying to implement the above code?
  10. A

    Button on From prefill field on different form

    I will upload a copy later tonight. Appreciate the help!
  11. A

    Button on From prefill field on different form

    Textbox has been changed when I updated the table. still same error.
  12. A

    Button on From prefill field on different form

    I gave your suggestion a try and renamed the table fields to ApplicationName and changed the MsgBox code. I am now receiving a compile error method or data member not found.
  13. A

    Button on From prefill field on different form

    My mistake code is now corrected to DoCMD with the appropriate spacing now i receive a run time error 2498 an expression you entered is the wrong data type for one of the arguments.
  14. A

    Button on From prefill field on different form

    Yes I received a Run-time Error "424": Object required. When I went to debug the command line Dicmd.OpenForm"Incident Library", OpenArgs:=Me.Application is highlighted yellow.
  15. A

    Button on From prefill field on different form

    I changed both tables fields from application to system and updated the code. When I click the button I receive a Compile Error: Method or Data member not found.
See more
Back
Top Bottom