Thread
:
change control source or value of text box
View Single Post
#
2
May 21st, 2010, 09:50 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
change control source or value of text box
Put the following expression in the first blank field in your query:
DueDate:IIF(IsNull(LineDueDate),POHeaderDueDate,Li neDueDate)
Then where you have line due date in your report, change its control source
to DueDate.
Be sure to use YOUR field names in the expression in the query.
Steve
"MNJoe" wrote in message
...
I have a report with GroupHeader0 and GroupHeader1. The data source of the
report is a query. In the GroupHeader0 I have the Purchase Order Header
info
which includes the Purchase Order due date. In the GroupHeader1 I have the
Purchase Order line info which includes the line due date. What I need is
if
the line due date is Null or blank to default to the PO header due date.
How
can I assign the header due date to the line due date. Can I change the
control source of the text box in VB programming.
--
MNJoe
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]