How to create a Form with one Combo Box that displays selected Fields from a Table

[RobFlott]

I have a Table with 5 Fields of sales data and am trying to create a Form that has one ComboBox from which the user selects one person (Field 1). Upon selection all the Fields with data relative to the selected name appears below the ComboBox.

I know this can be done using a 'Datasheet' Form and letting the user simply filter on the Name field, but I want to see if I could accomplish the same results using the ComboBox on a Form.

Please let me know if this can be done and if so how do I set this up.



Thank you

[ranman256]

Use a continuous record form, (not datasheet) with the combo in the form header.
when the user picks a person , filter the records...

sub cboPerson_Afterupdate()
   me.filter = "[personID]=" & cboPerson
   me.filterOn = true
end sub

[June7]

Controls on Continuous form can be arranged to look like Datasheet.

[Missinglinq]

Returning only a single Record, I'm not really sure why a Datasheet Form or a Continuous Form would be appropriate. You can let the Combobox Wizard do this for you:

If you haven't already done so, create a Form based on your Table, including all the Fields you want displayed.

Then simply:

• Add a Combobox to your Form.
• The Combobox Wizard will pop up
• Select "Find a record based on the value I selected in my combobox."
• From the Table the Form is based on, click on the Field you're searching by (a Field that is unique for each Record) to move it to the right side.
• Hit Next.
• Size the column appropriately.
• Hit Next.
• Name the Combobox something appropriate.
• Hit Finish.
  
  

Now you can drop the Combobox down and scroll down to the item to search by, or you can start to enter the item and the Combobox will "autofill" as you type. Hit <Enter> and the Record will be retrieved.

Linq ;0)>

[RobFlott]

ranman256,

Thank you for the quick response. I tried your suggestion but I'm doing something wrong and I cannot figure it out.

Where your code reads: me.filter = "[personID]=" & cboPerson does personID refer to the name of the Field? In my case the Field name is Manager, and I named the ComboBox cboManager.

So my code looks like this:

Private Sub cboManager_Afterupdate()
me.filter = "[Manager]=" & cboManager
me.filterOn = true
End Sub

But nothing happens when I make a selection from the Combo Box.

[RobFlott]

MissingLing,

Thank you very much.

I followed your suggestion and this worked.

Thanks again

Rob

[Missinglinq]

Glad we could help!

Welcome to AFN!

Linq ;0)>