Fields Won't Print

[polygonking]

Hi, (sorry to be cross-posting, but I didn't get any response from Modules and VBA)
I've messed something up, I think. But I'm not sure if I messed up VB or some connection in Access.

The Symptoms: I've got a print page with checkboxes that represent other form pages in my db.
The page basically prints ok, except where field information is supposed to be.
Wherever there should be field info, it prints #Name? instead. Each field can't seem to find it's info.

The funny thing is that the information displays correctly in the form onscreen.
Just not when I print.
Basically someone else wrote the the Print code and I've been hacking away to make this code work for 3 new forms (e.g. 3 new checkboxes).
While I'm not terribly familiar with VB, I know my way around script and I'm pretty sure I haven't really messed up that code.

How I got there:
At one point in my building of this thing, every time I went to open the 'print' page, I would get an error and drop into VB.
Well, this was driving me nuts, and at that point I hadn't altered the code. I was just trying to view the print page. So, I cleverly pasted into VB the code from an earlier version of the db. This cleared up the debug error nicely, and I was able to finish the code that would allow me to choose 3 new pages to print. But now it's doing the symptom above.

Any help would be appreciated.
Scott

 

[Uncle Gizmo]

I would imagine that it is printing "#name?" because the text box cannot find the table field it is pointed to. as you have indicated that this works OK normally, but doesn't work when you try to print, then I would suspect that some part of your print code is changing the record source of the form.

 

[Uncle Gizmo]

To finish off this post, I have spoken to Scott privately via Skype! And assorted the problem out.

Basically, what I think happened was, when Scott pasted the code from a previous version back into the form, the form controls lost their reference to the actual code. This is quite a common problem and I have seen it before.

However what I hadn't seen before, and this is an interesting point to watch out for in the future, the forms "load event" also lost its Reference to the load event code.

I would normally recommend that any discussion about Microsoft access problems should transpire on this forum, so that the history of the discussion is available as a reference for anyone else who may have a similar problem.

However this was my first opportunity to use Skype as a business tool, and I wanted to see how things panned out with Scott, because I think that direct one to one communication via Skype or similar programs could be, will be, maybe a viable business tool in the future.

 

[Rich]

Form are not designed to be printed, you should use Reports