PC Review


Reply
Thread Tools Rate Thread

Access 2003 setting default value on a form

 
 
Kev
Guest
Posts: n/a
 
      21st Apr 2009
Hi all,

Here’s my problem.
I’ll describe the objects first :

Table : Systems

System_id auto number
Name text
Location text
Comments memo
Level number (10, 20, 30, 40 or 50)

Eventually, users will have a level nr and will be able to
1. maintain entries equal to their own level nr
2. see entries less than or equal to their own level nr


Form : Systems

This is a simple form that has all the fields available for entry.
I’m intending to use this for both 1. and 2. above.


Macros :
For 1. Read_Level_10_Form, Read_Level_20_Form (etc)
For 2. Maintain_Level_10_Form, Maintain_Level_20_Form (etc)

Examples Macros :
Read_Level_20_Form
OpenForm Form Name Systems
View Form
Filter Name <blank>
Where Condition [Systems]![level]<=20
Data Mode Read Only
Window Mode Normal

Maintain_Level_20_Form
OpenForm Form Name Systems
View Form
Filter Name <blank>
Where Condition [Systems]![level]=20 (only maintain own level)
Data Mode Edit
Window Mode Normal


This works fine, until I want to create a new record.
I know how to set the default value of level in the systems form,
but I only know how to set it to a constant. I can set it to 10, or 20 …etc
What I want to do is set it to either 10, 20, 30 etc depending on which
macro called it.
Eg.
Maintain_Level_10_Form would set the default value to 10
Maintain_Level_20_Form would set the default value to 20 …etc

Hope this explains things.
Thanks in advance,
Kev.

 
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
Access 2003 - Setting default value of a text box Amanda Microsoft Access Forms 5 23rd Oct 2009 01:18 AM
set default value in field of form in Access 2003 New to this Microsoft Access Form Coding 4 13th Jan 2009 12:38 AM
"microsoft web browser" control in Access 2003: setting default font Spencer Steel Microsoft Access Form Coding 0 25th Jun 2008 04:45 PM
Setting a Default Printer inside Access form =?Utf-8?B?SGFuc2ZvcmQgY29ybmV0dA==?= Microsoft Access Form Coding 4 14th Jul 2007 04:23 AM
Default Setting for a New Form Ed Microsoft Access Forms 1 27th Apr 2004 08:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:42 PM.