Hi All,

I am hoping to create form that will prompt the user to enter default values for certain fields ie Week No and WB Date before allowing any data to be input into the form.

Any help on how to do this would be appreciated.

Thanks,

Mary

1) make all fields except the two you want completed first invisible
2) make the two you want completed first required fields
3) After update of second field make remaining fields visible

L

Thanks but I will be entering a number of entries with the same first two fields and only want to have to enter them once - looking at your suggestion I would need to enter these values for every entry - is there a way of doing this ie a box appearing which will set the default values????

Mary,

I think there are a number of ways you can do this if you'd like. You could use the "default value" property for controls. Or you could set the default in table design if the form is based on it. Or you could auto-fill these fields from the previous record's data when you go to enter a new record on the form. You said something about week number in your first post. Tracking data by weeks of the year would be good for the auto-fill option. Then all you would have to do is write a sub using Len's instructions...