Default Values

[dj_tigger1982]

Hey there all, I am new to this forum, so hello

I have designed a database in access 97 (all my work have) and I am creating a way to log of calls recieved by me to teh faults desk. This will be a way to store the information instead of using paperwork.

My question is this I have a drop down box that is called Call Closed and the Values are Yes and No. In the design view of the table I have set the default Value to = No so that automatically the form will enter this Value and hence I will not need to close the call unless I do it manually.

Cheers in advance

Mike

 

[Rich]

What's the question?

 

[ColinEssex]

Hi

It may be me but I'm not too clear what the problem is.

If you're saying about using a ComboBox to close a call - personally I would have used an OptionBox with 2 values (yes and No) and set the default value to No.

Others of course may have a different approach.

Col

 

[ColinEssex]

Also - if you're talking about the call status - how are you dealing with calls on "hold" that can't be fixed yet for some reason because presumably you won't want to include those in any count of "still open" calls because they may be waiting for parts or whatever

Col

 

[dj_tigger1982]

Sorry My Bad

The feild is called Calls Closed, and It is a lookup wizzard with the following Value's (YES and NO).

At present when I open the form to enter data I have to change the value in the Calls Closed Feild from Blank to NO. I want the default value of NO to be entered in here because I keep forgetting to set the status when logging the calls.

So basically How do I set the Value to automatically display the Value NO

Mike

Sorry for the confussion

 

[Rich]

Set the default value to No on the property sheet for the control

 

[ColinEssex]

I'm too slow again Rich!!!!!

 

[dj_tigger1982]

WOOOTIE cheers it worked.

I been at that for ages, and I was stuck

Thanks guys

Mike

 

[Rich]

I'm too slow again Rich!!!!!

Get a faster machine!