Just an update....I was able to get my form to pull the query data in and save it to the new record on my test DB at home. Going to try to recreate it in my "real" db tomorrow. Only quirk in my test was that the data pulled through into all three tabs of my form instead of just in the first tab...
Bob and Paul,
You guys have been great. I really appreciate all the help. After taking a breather from this over the weekend and using what you guys have told me I think I may have the solution. Let me give it a try and see what happens and I will let you know if it poses more questions (or...
OK everyone that has been helping me with this. In the old db that is working as I want my new DB to work I have found this:
Form Properties - On Activate - Event Procedure
Private Sub cmdCI_Click()
On Error GoTo Err_cmdCI
chkInsp = -1
If IsNull(txtDisk) Then
txtDisk = "0"...
Paul,
That sounds like it might be what I am looking for. Now to figure out how to read and apply the code to my situation. At least it gives me an avenue to research. Thanks!
JDraw,
I was able to remove the most sensitive data and condense the records down but would it be possible to send this to you in a PM. Not comfortable with posting publicly.
Thank you for your response Bob but I do believe you are speaking in a foreign language. It sure looks like english but I did not understand a bit of it :confused:
I apologize for my inexperience.
Charlene
Access 2010. I have a form pulling from a query to create a "To Do' list of sorts. On this form is a button to open an input form for the corresponding record (I hope). When this button is used I want it to pull certain data for that specific line from the query and input it into the new record...