Linking text boxes

[jer]

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

 

[jer]

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..

 

[vbaInet]

Is the control bound or unbound?

 

[jer]

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

 

[vbaInet]

Upload your db, let me see what you're doing.

 

[jer]

how do i do that?

 

[jer]

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.

 

[jer]

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

 

[vbaInet]

DoCmd.OpenReport ...

Upload your db -->

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[jer]

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

 

[jer]

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

 

[vbaInet]

Only the relevant bits and some test data.

 

[jer]

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

 

[vbaInet]

Remove the image field and control. I don't really need that.

 

[jer]

Here is a rough sample of the database.View attachment New Compressed (zipped) Folder.zip

 

[jer]

View attachment New Compressed (zipped) Folder.zip

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

 

[vbaInet]

Yep, I got it. I will have a look at it when I get a minute.

 

[vbaInet]

I don't see where the OpenReport command was used in your db. Upload exactly what you're trying.

And I thought we already told you not to have spaces and parentheses in your form names?

 

[jer]

View attachment New Compressed (zipped) Folder.zipSorry 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..

 

[vbaInet]

It is a bad thing

Back to your problem. Using the first record in the table, the Tool No is 856A3387G03 and the ID is 1. These two are not compatible neither are they the same.

Why don't you use the ID field instead?
Is Tool No# unique across all records?

Even if it's possible to do, you shouldn't be embedding forms in reports when you can easily embed a report as a subreport.