Search results

Thank you Everyone for your replies! I will take your advice and add a new field to the Providers Table and try to work it that way.

I'm just trying to have an unbound field [ProviderCheck] value update based on the what is entered into another field [Provider]. I keep getting a Type Mismatch Error. I've tried to change the format of the unbound field, but that hasn't worked. I'm sure I just have some type of syntax error...

That did it!!!!!!!!!!!!!!:):):):) Thank you so much, pbaldy!!!!!!

pbaldy, I used your suggested examples "referring to a form control" and I keep getting an invalid string/syntax error. =DLookUp("[Six Month Date]","DT6Monthqry","[CustomerID] = '” & forms!MainTestForm!CustomerID & “’”)

Thank you for your suggestion. I tried adding a single quote in front of CustomerID and also removing all the single quotes and both gave me the error- #Name?

I want to return a value from a separate query and have that show up in a field on my main form. The field name from the query is "Six Month Date" and the query name is "DT6Monthqry". I want to return the value displayed in the"Six Month Date" from the query, matching the CustomerID in the...

No, I didn't, I just tried removing the single '. But I now know what you are talking about and I'm sure it will help me in the future. Thanks again.

I got it now. I removed the " ' " in front of the And. Here is the code that works now: stLinkCriteria = "[Injury_No]=" & Me![Injury_No] & "And [RehabDate]=#" & Me![RehabDate] & "#" Thank you for your help, anyway.

I think I know what you are talking about. but when I run the form and click the button to open the report, it just gives me an error box and no choice to debug. When I'm in the Visual Basic box, and I try to "run" it, it doesn't do anything.

The spaces were automatically placed in the code when I copied and pasted, but when I copy and paste onto this forum, it doesn't reflect the spaces. I will try again

You are right, the code that is in there now was not what you sent, but I just copied and pasted what you had sent earlier, but I had to change it back to get the first part to work. When I used your code for the stLinkcriteria, is when I got the data type mismatch

Sorry, there is not a " ' " before the &. I just did that to make sure the first part of the code worked. And it did

No, the error occurs when I click the button to try to run the report. The report is based on a query, so the criteria is to limit the report. Here is the entire code for the button: Private Sub RehabReportBut_Click() On Error GoTo Err_RehabReportBut_Click Dim stDocName As String Dim...

Thanks vbaInet. I copied and pasted exactly what you have and now it is giving me the "Data type mismatch in criteria expression"

I'm getting a syntax error with the following string: stLinkCriteria = "[Injury_No]=" & Me![Injury_No] & "'And[RehabDate]=#" & Me![RehabDate] & "#" Can anybody tell me where I messed up? The field "Injury_No" is a number and "RehabDate" is a date field. I know with a date field the syntax...

I figured it out. Thank you so much for your help.

Thanks again Missinglinq. I must be doing something wrong because I can get that to work. Going off of your tag line "There's ALWAYS more than one way to skin a cat", I can't help but look at this another way. I tried to create a text box in Form2 with the control source "=[Filter]", thinking...

Thank you. I will look at the sample, but my form2 is not a subform of the Form1.

PNGBill, There is one button on Form1 that opens Form2 filtered by MemberID. On Form2 I added an Add Record Button, that I wanted it to add a record and populated the MemberID field with the data from the filter, since it is also the MemberID from Form1.

Thank you, Missinglinq. That worked great for the ones that already had a record associated with them in that Table2/Form2, but there are some Members that don't yet have a record in that Table2. I know I can run an Append query and put a record in for each Member, but is there another way you...