Select from a drop down box and have other fields updated.

S

Steve

I have a form which accesses a server information table. I
want it so that when I select a server from the server
name drop down combo box, it jumps to the record and the
other two fields are updated with the correct information.
Instead, when I select a server from the drop down combo
box, it justs changes the server name within the record
currently displayed. I'm fairly new to Access but have
learned alot already but I just can't find anything that
tells me how to achieve this.

Any clues, anyone? I think it may need some kind of event
procedure style code !!
 
R

Rick Brandt

Steve said:
I have a form which accesses a server information table. I
want it so that when I select a server from the server
name drop down combo box, it jumps to the record and the
other two fields are updated with the correct information.
Instead, when I select a server from the drop down combo
box, it justs changes the server name within the record
currently displayed. I'm fairly new to Access but have
learned alot already but I just can't find anything that
tells me how to achieve this.

Any clues, anyone? I think it may need some kind of event
procedure style code !!
Click to expand...

There are two common uses for a ComboBox in Access. One is for data entry
on a field where you want to provide choices rather than free-form typing.
This would mean that the ComboBox is bound to a field in the underlying
table (as yours appears to be). In this case changing the ComboBox entry
changes the current record.

Another use for a ComboBox is to *navigate* within the form's RecordSet.
That would mean the ComboBox is NOT bound and has code that runs when you
make a selection to take you to a particular record (that appears to be
what you want).

One of the wizard options when you drop a new ComboBox onto a form in
design view does exactly what you are looking for. So you should be able
to go to design view, make sure the ToolBox wizard is enabled and then drop
a new ComboBox onto your form. When the wizard comes up look for the
option...

"Find a record on my form based on the value I selected in my combo box."
 
Top