>Henry,
>If you're using a select statement then IMHO it's better to use RowSourcetype = 3.
Hi Cetin:
I am using RowSourceType 3. with the following code in the RowSource. There are two combos which have the same code.
SELECT app_time FROM timeslots INTO CURSOR AllTimeSlots NOFILTER ORDER BY app_time
App_Time is a numberice field which contains for example 800 (which we interpret as 8:00 AM0, or 1500 (which we interpret as 3:00 PM).
The objective is to allow the user to select the start time from Combo1 and the end time from Combo2 and store these values in varaiables mStartTime and mEndTime respectively. Later in a select statement i pupolate a cursor to find the find available timeslot for a date between the hours, as in this example 900 and 1500 (i.e., 9:00AM and 3:00PM).
Problem: If I select 900 as mStartTime and 1500 as mEndTime from each of the two combos and then query the values of the variable, I get the following:
mStartTime = 36.00
mEndTime = 60.00
Note that App_Time is numberic without any decimal places. I don't understand why this is happenning. Cna you send some light on this. Thanks.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons