Using a Combo box to display a specific record so it can be edited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was going to use a combo box to choose which record I want to edit, problem
is that is does not seem to be working. I also tried to use a form with a
tab control page on it to make it easier to read and sort my data.

Is it possible to do these two items and could someone help me get started.

Sam
 
To use the combo cox, you would have 2 columns the first (bound) column being
the key (probably autonumber column) with zero width (so hidden), the second
column being some identifying text. Then you could go to another form to
display the record whose record source could be the entire table with a
'filter' set to the record chosen.
A tabbed control on the form could be used to display the record's date thus
splitting the data up between several related areas. Look in Access Help for
how to set up a tabbed control.

Dorian
 
Have you tried by using the combo box wizard? ie make sure the wizard is
selected, place a combo box on the form where your information pertains,
select the wizards 3rd option being "Find a record on my Form....." and
follow the wizard from there.
 
Back
Top