G Gmoz Registered User. Local time Today, 23:05 Joined Jun 10, 2001 Messages 34 Oct 21, 2002 #1 [Forms]![frmSearch]![ReportMonth].Column(1) I have this on a Report in an unbound text box. I just cant get it to work, I am sure it is just a syntax error but any help is appreciated.
[Forms]![frmSearch]![ReportMonth].Column(1) I have this on a Report in an unbound text box. I just cant get it to work, I am sure it is just a syntax error but any help is appreciated.
C charityg Registered User. Local time Today, 23:05 Joined Apr 17, 2001 Messages 634 Oct 21, 2002 #2 =[Forms]![frmSearch]![ReportMonth].Column(1) ?
R Rich Guest Oct 21, 2002 #3 Is the form open when running the report? and Column1 is the second column in your combo
G Gmoz Registered User. Local time Today, 23:05 Joined Jun 10, 2001 Messages 34 Oct 21, 2002 #4 Yes the form is open and it is the 1st column
C charityg Registered User. Local time Today, 23:05 Joined Apr 17, 2001 Messages 634 Oct 21, 2002 #5 if you are looking for the value of the first column, you need [Forms]![frmSearch]![ReportMonth].Column(0)
if you are looking for the value of the first column, you need [Forms]![frmSearch]![ReportMonth].Column(0)
G Gmoz Registered User. Local time Today, 23:05 Joined Jun 10, 2001 Messages 34 Oct 21, 2002 #6 to be honest it was the = I was forgeting, comes from look at this thing for to long. Thanks for the replies guys it works great now
to be honest it was the = I was forgeting, comes from look at this thing for to long. Thanks for the replies guys it works great now
