PC Review


Reply
Thread Tools Rate Thread

cbo to pass report criteria variable to report, need help on IF statement

 
 
Kovax
Guest
Posts: n/a
 
      10th Mar 2006
I have 3 cbos: Employee Name, Report Type and Report Instance.

The user selects the Employee Name then the Report Type (this cbo is
populated through a SQL Union Select query run after selecting Employee
Name) then they select the Report Instance (populated through a SQL
Union Select query based on Report Type). The user then clicks a button
that prints the selected report instance, i.e. John Doe --> Performance
Report --> 10/10/06.

Problem is, the Report instance will be one of two data types: Text or
Date.
I currently have the Report Instance cbo data formatted as a date when
it is cited in the strlinkcriteria line but this does not work if the
data is text. How can I correct this? Is there a better way?

Thanks!!!!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate cbo based on other cbo if that cbo value exists in t Hugh self taught Microsoft Access Form Coding 0 21st May 2009 02:37 PM
Filter from Form cbo to Subform cbo =?Utf-8?B?V29vZHlBY2Nlc3M=?= Microsoft Access Form Coding 3 9th Nov 2006 05:03 PM
Populate cbo based on another cbo value hermie Microsoft Access Forms 0 23rd Nov 2004 05:05 PM
Populate cbo based on another cbo value Os Microsoft Access Forms 7 12th Nov 2004 02:37 AM
2nd cbo visibility based on 1st cbo Junior Microsoft Access Form Coding 3 10th Jun 2004 07:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:13 AM.