Search results

I was able make it work. One change that I was hoping to avoid. though; I need to have the record open on a newRecord. I tried using docmd.openform , , acNewrec on the Activate event. When I do this the code doesn't produce the search results. Is there a work around either with code or a property?

Thanks RG, I will try it.

It worked. Thanks. But, I by passed the search form. Which isn't really what I wanted it to do. I was hoping that the search form would produce what the onLoad did. When I use the record navigation, other records show that should only show in other forms show in this form. Is there a way to lock...

Well to further answer your question. I am trying to create a type of functionality. I would like one form to be the search form. and when you type your value in the inputbox, the code then opens the correct form and fills the fields with the data from table. It is worth noting that record...

Well, I am using More then one form. All the input forms stored the data in one table. I have 3 forms for input, one table. and 3 reports. There is about 12 fields total.

Okay, there is more then one field. But not even the ID field opens on the form. Basicly, I am attempting with the first form to find the record, then take the found record over and opening all the fields in that record in the form. Any suggestions??

I was under the impression the Me.bookmark would retrain the information from the search and when the form opens, the infor would load.

I agree, I use also this If formID = "BCK" Then DoCmd.OpenForm "AAA" End If to match the id to the right form. But I am not sure how to bring over the correct information.

My form finds the record, but when I click the button to load the information into another form, the info does not transfer from the search. Can any help? Here is my code: Private Sub Command8_Click() On Error GoTo handler Dim strID As String strID = InputBox("Enter ID...

I think I have got it solved. I tried this line that you provided earlier strSQL & "#" & Me.txtDate & "#," and the info went into the table properly. Thank YOU Bob and highandwild for the amazing help!!!!!!! :D

Bob, Yes the field name now is InputDate.

Okay, Let me try this again. Below is what is currently working; I would to add another field to my table with a Date/Time Datatype. But I am not sure how to write the strCriteria properly. Any assistant you can offer, I would greatly appreciate it! Private Sub cmdCreateRecord_Click() Dim ctl...

That is interesting, How would I then properly re-write this strCriteria = "[ID] = " & Chr(34) & Me.txtID & Chr(34) & [Date] = Me.txtDate & " And [Question] = " & ctl.Tag Thanks in advance for you help. :D

The Date will automatically be pulled from another input, like the ID. I have the ID and Date already working and being pulled when the Form opens so there is no need for any input because the fields are already populated. Below is what I have managed add to the code.. strSQL = "INSERT INTO...

I wanted to say that you have been extremely helpful. I am learning alot! I still have one more question. I would like add a [Date] column to my table. strSQL = "INSERT INTO tbl_Answers ( ID,Date,Question,Answer)" strSQL = strSQL & " SELECT " & Chr(34) & Me.txtID & Chr(34) & "," strSQL =...

I think I have solved my problem. I have left the code to the original. When I changed the tags and the table datatype, I forgot to add double quotes around the new tag name, i.e. "A1"

Ok, I am stumped..:o I made a change to a line of code. strCriteria = "[ID] = " & Chr(34) & Me.txtID & Chr(34) & " and [Question] = " & Chr(34) & ctl.Tag & Chr(34) & "" Also, I changed the Table [question] to TEXT from NUMBER. And in the form I change the Tags 1, 2, 3, 4, 5 --> A1, A2, B1, B2...

Thank you for the advise. If is okay with you, I may have a few more questions as I continue. Thanks! :D

highandwild, Wow, that is perfect! Thank you so much. I spent most of the weekend researching in how to create it straight into VBA and failed...:o I have a question, I took a look at the VBA code, and I was wondering if I could assign the ID from another form instead of a drop down...

I have a form with 26 questions. Next to each question I have a drop down menu that has: YES, NO, N/A My form pulls the ID from the main form, also the date does the same. My problem is kind of complicated. I tried to create a Append qry for each drop down and a master qry to run all of them...