jillywilly143
Last Activity: Jun 27 '17, 08:58 PM
Joined: Mar 30 '16
Location:
-
jillywilly143 started a topic Text box in Access report with controlsource from form only shows up on first page.in AccessText box in Access report with controlsource from form only shows up on first page.
I have an Access report in which the user chooses a month from a form, and it runs the report based on the parameter. I have a text box in my report that pulls the selection they made so that my report will show it. However, it only shows up on the first page. Every page after that says #Name?. Is there a way to fix this? -
Subform report with parameters
I have a subform that includes a report. The report is based off a query with parameters. The query runs correctly, but does not update the report on the form.
For example, if I choose a customer number, my query pulls all contracts for that client, but the report on the form does not change. -
I was able to fix it by Analyzing Performance. It said there was a module running in the background. Thank you all so much! -
If the Dlookup works on the copy, but not the original, does that mean that something in one of my events is causing the error?Leave a comment:
-
NeoPa,
I did try MBizup's suggestion and that did not help. I decided to make a copy of my DB to get rid of the confidential names, so that you can see this is really happening. The funny thing is that the copy works, but none of the buttons do anymore. So, I'm wondering if one my macros is the problem. Is there a quick way to look at that?Leave a comment:
-
I am not using VBA code for my Dlookup. I have it as the control source of an unbound field. So, when you say "Identify the line in your code before which you should insert the new line," I don't know where to look. I really appreciate your help and patience.Leave a comment:
-
I must be doing the Debug wrong. There is nothing in the Immediate pane.Leave a comment:
-
Seth,
A value is returned when I remove the criteria. AvatarNumber is a number value.
This is what my Ctrl+G pulled up
Private Sub Text479_BeforeU pdate(Cancel As Integer)
End SubLeave a comment:
-
Thank you guys so much. I feel like I was not very specific. I have a table with client information. AvatarNumber is their unique customer number. I have 2 forms. One that is for entering their contract and one for entering their payable information. On both the table, and on both forms, the field is called AvatarNumber. On the payables form, the Dlookup works. It is the exact same Dlookup as the contract form. The contract form used to work, and...Leave a comment:
-
Yes, they both have it. It can be Null on a new record.Leave a comment:
-
Dlookup works on all forms, except one.
I have the following Dlookup:
It returns #Name?, but it is the exact same formula on the other forms in my database that work.Code:=DLookUp("LastName","ClientT","AvatarNumber=" & [Me].[AvatarNumber])
Please help. :)
No activity results to display
Leave a comment: