Search results

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.

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...

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?

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.

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...

Thanks for all your help really appreciate it!

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...

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.

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?

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

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

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.

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.

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.

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.

Ok, To recap I have a onclick event of the below: Private Sub Command58_Click () DiCmd.OpenForm"IncidentLibrary", OpenArgs:=Me.Application End Sub Would the red text above refer to the field name I am using in my table for the application field on my form) My field name in both tables for...

Sorry if these are newbie questions. When you say you would then use it in the other form, like: Me.ApplicationID=Me.OpenArgs Where would I insert this code? Thanks

Thanks theDBguy, I guess my confusion is on how I would finish the code. Currently what I have in place to open the form on button click is below. Private Sub Command58_Click ( ) DoCmd. OpenForm "Incident Library" End Sub

I have a database that is tracking incidents that occur by application. I have two forms one that holds all the applications information named Application Library and another form labled Incident library. I have a button on the application form that when clicked will open the Incident form to...