Combo Box not putting information into form

[Learning Access]

I made a combo box and it appears that I can see all the information to
select an employee to select, but when I do select a person, the information
is not pulling down into the form and the following tabs. The very first
employee in the table shows up properly but no other people in the combo box
will dump down into the form....any suggestions? I tried to take a close look
at properties, but which area would this deal with? I even tried to look at a
template that has a similar set up to see if I could compare the template to
mine and nothing....Help!!!

 

[BruceM]

It may be best to start with a clearer understanding about how Access works.
This tutorial is a good place to begin:
http://allenbrowne.com/casu-22.html
The Index of Tips at the bottom of the web page contains a lot of
information, too, as well as the Links link on Allen's web site.

To the question at hand, what is the form's Record Source? Is the combo box
bound to a field, or is it an unbound search box? It sounds as if it could
be an unbound combo box, with no After Update code to direct Access to the
selected record. If it is unbound, how did you create it? Does it have
code? The properties to look at may include Control Source, Row Source, and
anything listed on the Events tab.

 

[Jeff Boyce]

Beth

There is nothing inherent in a combobox that tells Access to take the value
selected and make THAT record the one to display in the form. You have to
do the work to tell Access to do that.

The generic approach is:
* a combobox to allow selection
* a query that 'feeds' the form, but uses the combobox for a selection
criterion
* an AfterUpdate event procedure for the combobox that tells the form to
requery its source.

So when you first open the form and see the first record, it must be that
the form is pointed at the source of data and is showing the first record.

If you implement the above approach, the form opens pointing to the record
that the query provides, which, since there's no selection in the combobox
yet, is NONE! Then you pick an item in the combobox and the AfterUpdate
code tells the form to rerun the query, which DOES see a value in the
combobox now, so loads THAT record.

Is that what you were looking for?

Regards

Jeff Boyce
Microsoft Office/Access MVP