Re: Make default value "real"
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 12 Aug 2008 14:54:12 +0800
Allison, I'm not 100% clear about what you want to do here.
Are you saying that every time the user enters a new record in the main form, you want to automatically insert the 'blue' record into the subform's table as well? If so, you could do that by executing an append query statement in the AfterInsert event procedure of the main form.
I'm not convinced that's a good idea. Does 'blue' really apply to everyone? There are cases where this is valid, but not as a general rule.
If that's not what you want to do, then it might be best to leave the combo's Default Value blank, so it's obvious to the user that they must select 'blue' if they want it.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allison" <Allison@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:041CB1BD-7C47-468D-BF6B-891BEB43E48C@xxxxxxxxxxxxxxxx
Access 2003 SP3
Win XP SP2
I have a sub-form with a single combo box. The combo box is tied to a
table, and the subform is tied to a table that combines the main from ID and
the value of the combo box and creates an entry. (Relational yes/nos from
Allen Browne: http://allenbrowne.com/casu-23.html ).
I've set the default value of the combo box to "1", which displays my first
entry option (let's cal that "blue"). This displays the word "blue" but
doesn't actually capture it to the combination table in the same manner that
it would if "blue" were SELECTED, not just displayed.
Is there a way to SELECT a value by default - not just display it?
.
- Follow-Ups:
- Re: Make default value "real"
- From: Allison
- Re: Make default value "real"
- References:
- Make default value "real"
- From: Allison
- Make default value "real"
- Prev by Date: Re: Retrieving data from recordsets
- Next by Date: Re: Set focus not working properly
- Previous by thread: Make default value "real"
- Next by thread: Re: Make default value "real"
- Index(es):
Relevant Pages
|
