Search results

Thanks so much! Its working now. It tranfers the information in the text boxes but as i said before, I have images that change with records but it is not changing these with each record. The report is keeping the same image all the time! :( any ideas? Do i need to reference the image controls in...

Here is the code I used now for my db; DoCmd.OpenReport "Copy of Main Form (Search By Tool Number)", acViewPreview, , "Tool No# = '" & Me.[Tool No#] & "'" However I get a runtime error 3075, syntax error missing operator in query expression '(Tool No# = '856A3387G03')'. The tool number changes...

Yep! that makes sense

Im still not following you. Im sorry but im a real novice at this!

Is it the fact that the report cant recognise where to get the information? I tried making a query based on the form n then the report based on the query but it got messy and i didnt have enough experience to pull it off. I was using the Forms!FormName!Textbox.value reference. I dont know if the...

I setup the ID Field so that I could assign a primary key to it to individualise the tools because there are two or three tools in the full database with the same serial number.

Id Field.. You mean use ID field in the combo box? The tool number and serial numbers are different all across with some tools only having one or the other. I copied the form as a report so that I would have an exactly the same template.

Sorry about that. Here is a sample. But in my actual db there are spaces in the names because i didnt know that was a bad thing.. :(

Here is the sample upload. Let me know if you get it!! Thanks

Here is a rough sample of the database.

Will this cause errors because I have images that change with every record and the filepaths will be invalid when i send..

I can upload a sample, not the full one due to confidentiality

I dont think I can upload my database because im representing the company

OpenReport "Tooling RPT", acViewPreview, , "ID = '" & Me.[Tool No#] & "'"

I changed the name of the report and editted the code now the error im getting is a compile error. Telling me the sub or function is not defined.

how do i do that?

The controls in the report or the form? All the controls (textboxes) are bound in the form and the report.

Hey Nigel, ID is a column I created with the numbers 1 to watever. Basically it is the primary key but it is not an autonumber..

Ya i put that in before the DoCmd.OpenReport part of code and I still got that runtime error...

Im still getting the run time error 3071. It says the expression is typed incorrectly or its too complex to be evaluated. Any ideas because I got no clue :(