How to show related data when I select reference item in a form?

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

Guest

Dear All,

I'm going to make a form. I build a table which has a key ID and other data.
I build a form with this table. My goal is that when I type in or select the
key ID field in the form mode, all the related data will be shown
automatically in the form. Then I can make any data editing within this
record. How can I do this?
 
Easiest way is to create an unbound combo box in the Header of the form that
will jump to the record you select. The Button Wizard has an option for
that (it's the third one on the first screen). If you want an example, on
my website (www.rogersaccesslibrary.com) is a small Access sample database
called "ComboChoosesRecord.mdb".

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Hi Roger Carlson,

Thanks for your help indeed. I add the combo box in the header as well as
your example. However, the data record in the detail area will not be changed
to the related record I chose. Is there any setting missed? Does it need to
make something setting that linkup the header and the detail area or the
combo box and the records' field?


Roger Carlson said:
Easiest way is to create an unbound combo box in the Header of the form that
will jump to the record you select. The Button Wizard has an option for
that (it's the third one on the first screen). If you want an example, on
my website (www.rogersaccesslibrary.com) is a small Access sample database
called "ComboChoosesRecord.mdb".

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Click to expand...
 
Hi Aries,
The advice Roger gave you was 100% correct and should have worked.
Delete the control in the header and try it again ... here it is step
by step.
- Open the Form in design View and check that
Properties->Data->RecordSource has a query or table in it.
- On the ToolBox, make sure the Wizard button (Stars & Wand) is
selected
- Click the ComboBox button and draw the ComboBox into the Header of
the Form
- The Wizard will open a page for you to select what you want the
ComboBox to do
- You must select the third option which says something like "Select
the record according to the selection I make"
- On the next page, you must then indicate to the Wizard which is the
field that you want to link to - this will be your ID field

If that doesn't work then we need to inspect in much more depth your
data and the forms design

Cheers
Brett

Hi Roger Carlson,

Thanks for your help indeed. I add the combo box in the header as well as
your example. However, the data record in the detail area will not be changed
to the related record I chose. Is there any setting missed? Does it need to
make something setting that linkup the header and the detail area or the
combo box and the records' field?
Click to expand...
 
Back
Top