Displaying records dependant on combo box

[Col Mc]

Hi

Any ideas on how to autofill the rest of a form when i select from a combo box?

ie when i choose a name from the list i want the rest of the form to populate with the rest of the data relevant to the selection.

Cheers

 

[Fransdekock]

Hi am not sure if this is exactly what u want. But....put all the fields u want populated automatically on ur form and u can use the combobox wizard that comes with ms access. Just click the third option called find a record on my form based on the value from my combobox.

U can also use this code

Private Sub Combo28_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[fieldname] = " & Str(Nz(Me![Comboboxname], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

 

[MStef]

I think you need something like "DemoComboBA2000.mdb".