Re: auto fill form based on combo-box selection
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Tue, 10 Apr 2007 11:52:24 -0700
If I'm understanding your description, you want to be able to display
corresponding values once a selection is made. If the ONLY thing you are
doing is displaying those looked-up values, and are not planning on
(re-)saving them (i.e., the controls are unbound), then you could easily do
that by:
> include the values you will want shown as fields in the query you use to
feed the combo box
> create an AfterUpdate event for the combo box
> in that event, add something like:
Me!txtSprayArea = Me!cboRecipeName.Column(1)
Me!txtGDL_Material = Me!cboRecipeName.Column(2)
...
Check Access HELP on using .Column(n) -- it is zero-based, so you start
counting at "0".
Regards
Jeff Boyce
Microsoft Office/Access MVP
"J" <J@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA153100-F574-4F83-92E3-B2169FC1DFCD@xxxxxxxxxxxxxxxx
Instead of creating several forms with different default values, I would
like
to "auto-fill" some of the fields based on the value selected on the first
combo-box on the form. The defaults would come from a table. For example
tblSpecs would contain RecipeName, SprayArea, GDL_Material, etc. On my
form
when the user selects RecipeName, the vlaues for SprayArea, GDL_Material,
etc
would auto fill with the corresponding values from the table where
RecipeName=RecipeName. I think this is probably do-able but I don't have
much
coding experience. Help is greatly appreciated.
.
- Prev by Date: ItemsSelected
- Next by Date: Re: ledger form and binding vs queries
- Previous by thread: ItemsSelected
- Next by thread: Re: auto fill form based on combo-box selection
- Index(es):
Relevant Pages
|
