Hi,
I am a relative newbie.
How to create a form that populates from a drop down selection ? I already have the drop down working I want that to populate a form. How can I do this ?
Hi,
I am a relative newbie.
How to create a form that populates from a drop down selection ? I already have the drop down working I want that to populate a form. How can I do this ?
In the AfterUpdate event of the combobox on the form(change those names below to your names):
Me.Filter = "FieldInTable = """ & Me.ComboBoxName & """"
Me.FilterOn = True
Thought you already have a form with a dropdown or combobox field on it?
No I have the drop down already set up, what is the best way to go from here for data to appear below ? How do I it so the data changes to the drop down option ?
"I have the drop down already set up" what does that mean, you have a query that returns the values you want in a list? Or you have a table with the values?
So you create a form based on a table or query, then on the form add all the fields from the table or query, then at the top create a combobox object and use wizard to get your list.
I have 3 relationship drop downs set up"I have the drop down already set up" what does that mean, you have a query that returns the values you want in a list? Or you have a table with the values?
So you create a form based on a table or query, then on the form add all the fields from the table or query, then at the top create a combobox object and use wizard to get your list.
a connect to b and b to c (eg)
choose from a, then b and c
I then want to c to trigger off the details for a sub form etc rather than using the wizard I want to take the values from drop down C
You are confusing us with the word "drop down". If you have a field on a table with a down arrow symbol, that is a table lookup. If the field is on a form then it is a combobox. Table lookups are not recommended at all, they cause confusion and strange behavior.
To create a form:
- go to Create>Form Wizard and create a form based on the table or query you wish to use
- add a new field - Design>Combobox
- set its Row Source property to show the fields you want to filter the form with
- in its AfterUpdate event in VBA:
Me.Filter="FieldFromTableName=" & Me!comboboxname
Me.FilterOn=True
Me.Requery