Very Confused Newbie

W

Wizard

Hi All,

Hope Sombody could help me?

I`ve created a form with 5 Feilds on, 4 Combo Boxs, everything works great
data updates and deletes fine. The navigate is a bit clumbsy with me having
300+ records. I was going to use a ComboBox as suggested by a few ppl on
here, but i want to be able to find by either field 1, 2, 3 or 7. What i`ve
done now is add a Subform as a Datagrid so it list the info in the datagrid.
Great it all displays and I can search through it no problem.

My question is how do I get it so that when I click on a record in my
datagrid it pulls the data up in my primary form, and pupulates my Combos
and Text Box`s?

I hope i`ve not confused ppl to much?

Cheers and Many Kind thanks
Si
 
L

Larry Linson

First, create a continuous forms view Form to replace the datasheet view in
the Subform Control. Then use the Field or Fields which uniquely identify
the records to modify the SQL in the main Form's Record Source. Save the new
RecordSource. You may need to Requery the main form, too.

Larry Linson
Microsoft Access MVP
 
Top