Re: auto fill form based on combo-box selection

Tech-Archive recommends: Speed Up your PC by fixing your registry

So it sounds like you are considering re-storing the same data multiple
times. This sounds more like what you'd do with a spread*** than a
relational database.

Have you looked into relational database design, and "normalization"? You
really won't be able to get the best use of Access' features and functions
if you feed it '*** data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"J" <J@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:516AF9DD-1741-46B0-9DB8-2AEB6D5EA544@xxxxxxxxxxxxxxxx
No, I plan to save the data, either the default (pre-filled) value or a
changed value if the user over-rides the default.

"Jeff Boyce" wrote:

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.





.

Quantcast