Recent content by smelly

The error I found was in the control source key on the reports LAB ID. It was just LAB ID so I changed it to Table1a.LAB ID and now it works. But that button on the form doesn't seem to be working properly. I made the button using the wizard and the form doesn't close so I don't know what...

Ok, I found the error! The query works by itself and the report works by itself but when I use the form with the print report button I get a blank report. Do I have to send the beginID and endID in? Thanks again for your help, i am nearing the end of this mess so hopefully I won't bug you too...

I did just that but it has the exact same error message. My new criteria is this... Between [Forms]![PrintILS]![BeginID] And [Forms]![PrintILS]![EndID] but it still spits out the error about the ....'[Lab ID]'..... Do you know what the problem could be? Thanks!

Running out of time and getting desperate. Please forgive me for posting in tables forum also. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer...

Hi, Yet another problem, big surprise. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer to more than one table listed in the FROM clause of your...

Can a datasheet from a table have many sub datasheets? I have a project number that can have up to thirty tests performed on it and I would like to show all the tests listed under the project number as a sub datasheet. I was thinking a query might be better but I wouldn't know how to do this...

Yes, I did not have in the after update event and now it works. You are the best. THanks!

Yes it is the first column. I will try 2 and see if that brings up the right text. I also tried that DLookup and I just get a blank in the text box. Is this the right code for the DLookup function. =DLookUp("[Company Number]","[Clients]","[Text52] = Form.[Combo6]")

I tried this code.... Me.Text52 = Me.Combo6.Column(0) and I get this in the text box... #Name?

Ok, I will do that-thanks!

Nope, it only has the company name column in the combo box. Is there a way I can get the company number from the table without having it in the combo box?

Hi again, I have one more question. I have a combo box on a form where the user selects a company name. After selecting the comapany name I would like to have a text box on the form displaying the company number corresponding to the comapany name the user selected from the combo box. Do...

Great, I finally figured it out. There was a glitch in my linking fields. Thanks for your help!!

Thanks for your help. I do want it to show in the datasheet view so they can see an overall picture of what projects are working for the clients. I will keep working on it and see if I can find an answer to my problem. Thanks again!

It is saving to the projects table but when I look at the record in the clients table and click on the plus box it shows the projects table with nothing saved in it. THank you!