Need Help defaulting a Drop Down List Box 
Author Message
 Need Help defaulting a Drop Down List Box

Hi

I'm pretty new to Access (V2) and need a little help

I need to default a drop down box to week ending date for the previous
week ie. if you enter the form on the wednesday it will default the
box to the previous Fridays date.

I have a table setup with each weekending date until year 2000 but
can't work out how to set the drop down box to pick up the previous
week ending date from the table.  There is probably an easier way
using code and would appreciate any help.

Thanks

Mark



Wed, 02 Aug 2000 03:00:00 GMT  
 Need Help defaulting a Drop Down List Box

I did this in 97 but it should work in 2

Function LastFriday() As Date
  Dim varDate As Date
  varDate = Date()
  LastFriday = DateAdd("d", WeekDay(varDate, 6) - 7, varDate)
End Function

Quote:

>Hi

>I'm pretty new to Access (V2) and need a little help

>I need to default a drop down box to week ending date for the previous
>week ie. if you enter the form on the wednesday it will default the
>box to the previous Fridays date.

>I have a table setup with each weekending date until year 2000 but
>can't work out how to set the drop down box to pick up the previous
>week ending date from the table.  There is probably an easier way
>using code and would appreciate any help.

>Thanks

>Mark



Fri, 04 Aug 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Need Help defaulting a Drop Down List Box

2. unbound drop-down list box to limit the values in another drop-down list box

3. drop down list w/out drop down box

4. Drop Down Box depending upon another Drop Down Box

5. Need to change font size of drop down list boxes

6. Data Validation Drop down list ( make longer drop box)

7. Need Help!! Coding a drop down list

8. Help required - Drop Down List Boxes

9. Newbie Needs Help With Setting Up A New Drop Down List

10. need help linking drop down list to second sheet


 
Powered by phpBB® Forum Software © phpBB Group