Auto-Fill in a form 1

[matpj]

Hi,
I have linked an Oracle Table into my Database.

I have created a form which takes 6 fields from this table:

EV200_EVT_DESC - Event Description
EV200_EVT_ID - Event ID
EV200_START_DATE - Start Date
EV200_END_DATE - End Date
EV200_MI_DATE - Move in Date
EV200_MO_DATE - Move Out date


Obvioulsy when this is done and open, I have a form with the same amount of records as there are in the Oracle Table.

I want to be able to have the form as one single record, but with a pull-down list of the events, so that when the user selects one of the events - all of the other details are filled in.
How can this be done. Can you tell me if I need to create queries/subforms or a blank replica table in Access etc?
If you give me the overall picture, I can try this and then ask any detailed questions after - if needed.
I appreciate your help,

Matthew

 

[Rohdem]

Here is one possible approach: Create an unbound combo box at the top of the form with the row source set to the list of event descriptions. Create a subform beneath this combo box that shows the rest of the information in the table. The EV200_EVT_DESC field does not need to show up on the form, but needs to be in the underlying query for the subform. Also in the underlying query, set the criteria for EV200_EVT_DESC to:

Forms!formname!comboboxname

Now, on the after update event of the combobox, requery the subform:

Me.subformname.requery Mike Rohde
rohdem@marshallengines.com